I have created an SQL query that returns me elements from a film table that satisfy one of two conditions. They are either the most profitable (gross - budget) or the least expensive movies to make. However, i wanted to…
I have a table with payment history payments: id consumer_id amount created_at 1 1 30 2021-05-11 13:01:36 2 1 -10 2021-05-12 14:01:36 3 1 -2.50 2021-05-13 13:01:36 4 1 -4.50 2021-05-14 13:01:36 5 1 20 2021-05-15 13:01:36 In final result…
I have a Users table (id, name, created_at) and a Transaction table(id, user_id, created_at, amount). For each month, I would like to know the number of users who did not have any transaction in the 3 months interval before that…
Let's say I have the following PostgreSQL table called products which has millions of records: CREATE TABLE IF NOT EXISTS mytable ( id serial NOT NULL PRIMARY KEY, label VARCHAR(50) NOT NULL, info jsonb NOT NULL, created_at timestamp NOT NULL…
I have a table Table name - commands id name status group_id id - number name - string status - 0 or 1 group_id - number I need to sort as follows: for all elements with the same group_id I…
How do you run an "order by" and then "replace" string, but keep the order? Context - I need the string "column_name" to be in the first line, hence using "zzz_column_name" to force it in the order by. And then…
From this dataset: mysql> SELECT * FROM document_signature; +----+-------------+-------------+---------+-------+-----------+ | id | document_id | employee_id | user_id | order | status | +----+-------------+-------------+---------+-------+-----------+ | 1 | 1 | 2 | NULL | 0 | SIGNED | | 2 | 1…
I have two tables contacts and calllist. contacts has multiple columns containing phone numbers. calllist has only one column from_number containing phone numbers. I'm trying to get all phone numbers from the column from_number which do not match the phone…
I have a table called Sets for LEGO: set_number (Primary Key) set_name other_fields 123 Firetruck abc 234 Star Wars abc I have another table called Parts for LEGO: part_number (Primary Key) name set_number (references set_number from Sets) 1 Truck Roof…
I have a table with different people that got different grades. I need to find the two persons with the highest grades. And if there is any ties, select them aswell. The only thing ive got right now is the…