I have a database (PostgreSQL) where there is a main table student, additional information amount and 3 dictionaries. I make a query with grouping by three fields of dictionary IDs, output the number of objects and the amount from an…
I've faced a strange SQL query like ALTER TABLE some_db.some_table ADD COLUMN metadata_labels varchar(255) DEFAULT FALSE; I'd expect it to fail because I'm adding a Boolean default value for the varchar column. But at least at Postgres, it is executed…
I have a multi-join query that targeting the hospital's chart database. this takes 5~10 seconds or more. This is the visual expain using mysql workbench. The query is below. select sc.CLIENT_ID as 'guardianId', sp.PET_ID as 'patientId', sp.NAME as 'petName' ,…
In the following data: id_1 id_2 colA colB colC 1 2 2022-01-02 scroll fast 12 1 2 2022-01-02 scroll fast 12 1 3 2022-01-03 scroll fast fast 11 1 3 2022-01-03 scroll fast fast 11 1 3 2022-01-03 scroll fast…
I have the following line of code that keeps giving me an error that Engine object has no object execute. I think I have everything right but no idea what keeps happening. It seemed others had this issue and restarting…
I have the following orders table: (1, 2, '2021-03-05', 15, 'books'), (1, 13, '2022-03-07', 3, 'music'), (1, 14, '2022-06-15', 900, 'travel'), (1, 11, '2021-11-17', 25, 'books'), (1, 16, '2022-08-03', 32, 'books'), (2, 4, '2021-04-12', 4, 'music'), (2, 7, '2021-06-29', 9,…
I'm trying to convert the date field from YYYY-MM-DD HH:MM:SS:MS to MM/DD/YYYY format in a view using Snowflake database with below condition: TO_VARCHAR(DATE(SRC_DATE),'MM/DD/YYYY') I'm able to convert the date to expected format with above condition, but when I try to…
I have two tables, from which I need to select the latest purchase of each customer from the US. The query must present the user_id and the purchased item columns: (I left out some of the records from both tables)…
I have table (t_answer) like below: user_id created_at answer 1 2023-01-01 1a 1 2023-01-02 1b 1 2023-01-11 1c 2 2023-02-05 2a 2 2023-02-20 2a I want to retrieve the rows within an interval of 1 week starting from each user's…
Is it possible to add a comma between each character of a string on mysql. From my_table id name 1 hello To : id name 1 h,e,l,l,o