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
This query works good but ignores the AND members.active='1' condition completely. It delivers always the same results, no matter if active is 1 or 0. Any idea? select amount, count(*) AS quantity from ( SELECT participations.member_number, COUNT(participations.member_number) AS amount FROM…
I have a varchar column {" l l": 2, " m m": 2, " xs xs": 2, " xxs xxs": 2, "s s": 0, "xl xl": 0} How do I filter it to get only keys with values greater then…
Say we have this table: create table if not exists template ( id serial primary key, label text not null, version integer not null default 1, created_at timestamp not null default current_timestamp, unique(label, version) ); The logic is to insert…
I have following tables: Parent: id status 1 SENT 2 CREATED Child: parent_id status 1 a 1 b I have a following select statement: select count(distinct parent.id) as all, count(distinct parent.id) filter (where parent.status = 'CREATED') as new, count(distinct parent.id)…