I have the following SQL: SELECT id, user_id, coordinates FROM fields WHERE id IN (SELECT field_id FROM transactions WHERE id IN (11,10,12)) There are 2 tables: transactions and fields. Both of them have their own id field. However, in transactions…
I'm super rusty with databases and haven't got the chance to work too much with them in the past 6-8 years, so there are some things that are uncertain for me. Let's assume I have a simple bi-directional one-to-many situation:…
I want to add a new column that is NULL for existing rows, but has default value for new rows. This: ALTER TABLE foo ADD COLUMN bar timestamp NULL DEFAULT clock_timestamp(); Won't work, because it would add default value to…
There are 2 tables, main_table and other_table. A user is allowed access to main_table items if his user_id matches the main_table.user_id column or if there is an entry in other_table where his user_id is in the read_acl column (array using…
I'm trying to select the row that contains the largest number and have accomplished it using this fairly simple query: SELECT s1.score, name FROM scores s1 JOIN ( SELECT id, MAX(score) score FROM scores GROUP BY id ) s2 ON…
I'm trying to update rows in a single table by splitting them into two "sets" of rows. The top part of the set should have a status set to X and the bottom one should have a status set to…
I have the below query that takes so much time >> table size 64.31GB are there any rewrite possible for this? SELECT MIN(ut.id) AS minUT, MAX(ut.id) AS maxUT FROM user_tasks ut JOIN user_tasks_metadata utm ON utm.user_task_id = ut.id JOIN ue_events_base…
I would like to insert multiple rows in a table. All of these rows will have the same values. The number of rows is not fixed but come from an input label in the frontend ($Num variable). How can I…
I have a table of users who have subscribed to different plans of a streaming services and other data about the said users. Something similar to this, Name Plan Status Subscription Date Cancel Date Ajax 5-user Active Jan 2021 -…
Suppose I have a table 'results' that looks like this: student | score | passing_grade 1 | 50 | 70 1 | 30 | 50 2 | 90 | 50 2 | 80 | 100 I want to count, for…