I have heard I should avoid cross join so my question is how you would rewrite this query without cross join ? SELECT p.*, po.*, pt.* FROM product p CROSS JOIN LATERAL ( SELECT json_agg(name) AS product_options FROM product_options po…
I select some tables with json_agg and json_build, all works but I got some data that I dont want it, My product_media (pm) is empty there are no images, if I use json_agg(json_build_object)) then I got 3x times all rows…
New to MYSQL. I'm trying to create a query that essentially selects employees who have mentored more than 2 people. The mentored_by column uses the SSN of employee's to tell who has mentored who, So you can see that that…
I'm trying to figure out a way to list all numbers between two columns (INT) and join them in a third column where all numbers are seperated. Eg. Column A Column B Column C 100 105 100;101;102;103;104;105 10 14 10;11;12;13;14…
I have this user_id which works as a FK for both tables of station and types . Data definition: create table public.types ( id uuid not null default uuid_generate_v4 (), name text not null, price numeric(10, 2) not null, user_id…
Here is my array for JSON I am trying to creating a JSON array with this code and then inserting the data in my sql but it is not working with inverted comma like "The text is with inverted comma's"…
I'm trying to create a query where if customers took 1 trip that day, then they would have to pay the price of a single ticket (200). If they took 2 trips on the day, then they would have to…
I have an SQL script, which returns the data from a Clickhouse table in amount of ~23k rows. I want to insert that exact data into a table in MySQL. Since they're two different DBs and there's no proxy to…
I have an exercise where I have to rewrite a query without using the NOT EXISTS. For example, I can have this query that is for getting all the employees older than 30 that are not managers: SELECT * FROM…
My table name is participant_preference and the column name is 'value' and the JSON is in the column as below, { "DiaryUsers": [ { "UserId": "HUGWFJJ6", "IsDiaryVisible": false, "ParticipantName": "Dr. Mckenzie, Alistair G [SP000024]", "Status": "A" }, { "UserId": "HUV65PV1",…