I got this MySQL query, I need to join both tables apps and contacts, but I am getting this error: MySQL said: Documentation #1054 - Unknown column 'messages.app_id' in 'on clause' My query: SELECT `messages`.*, ( SELECT COUNT(*) FROM messages…
I havetwo table like this Table:customers Table:orders and want to display like join I've tried select concat(c.first_name, ' ', c.last_name) as customer_name, COUNT(o.customer_id) as total_orders, sum(o.amount) as total_amount_order from customers c join orders o on c.id = o.customer_id where o.amount…
I have a table in Postgres named personal_profit as shown below: date profit 2022-09-22 4000 2022-04-25 5000 2022-01-10 0 2022-02-14 0 2022-04-12 2000 2022-05-06 1000 2022-06-13 0 I want to get total profit ordered by month but starting with the…
How can I generate the equivalent of this (postgresql) query in eloquent WITH result as ( select *, order_id as alias_id from orders ) SELECT * FROM result; I should be able to pass the inner query as eloquent builder…
I am trying to call categories but only if a document is assigned to those categories. The document has the categories stored as a JSON type. In the WHERE it is only bringing back the rows that have document uids…
How can I make MySQL throw an error (not simply issue a warning) when I try and perform a mathematical operation with text in the SELECT list. For example: SELECT 'foo' * 'bar'; I want that query to fail.
I'm having a bit of trouble with getting a select statement to work correctly. I have the following tables: recipe recipe_ingredient pantry recipe1 ingredient1 Ingredient1 recipe1 ingredient2 Ingredient2 recipe2 ingredient3 I want a select statement that returns recipes when the…
For example, I have this table that contains two specific brands - 'Ford' and 'Subaru', which just so happen to be the top earning brands for the Eastern and Western markets respectively. To obtain this info, I make a view:…
I have the following query: select product_name, (select bid_price from bids where bid_id = current_bid_id) as final_price from items where close_date > '2023/01/01' and close_date < '2023/02/01'; which outputs: product_name final_price ball 20 bat 30 hockey_stick 50 Instead of this,…
Why is the below code not valid. I have only used immutable columns. Below code is supposed to add a new column to the users table. There are few conditions that needs to meet for the is_valid column to be…