So, next problem :'), I have the following query that @MatBailie provided to me here (thanks again!): SELECT taskname, employee, SUM( DATEDIFF( LEAST( enddate, '2023-12-31'), GREATEST(startdate, '2023-01-01') ) +1 ) AS total_days, FROM schedule WHERE startDate <= '2023-12-31' AND endDate…
CREATE VIEW A1 AS SELECT client_ID , COUNT(dog_id) FROM test_clients GROUP BY client_ID HAVING COUNT(dog_id)=2; CREATE VIEW A2 AS SELECT filial , COUNT(A1.client_ID) FROM A1 JOIN test_clients USING (client_ID) GROUP BY filial HAVING COUNT(A1.client_ID)>10; SELECT COUNT(filial) FROM A2; As far…
I want to display some statistics to users that entered a command and I'm using to different SQL queries for that. The first one: SELECT COUNT(*) FROM guild_finished_giveaways WHERE guild_id = {} AND winner_id LIKE '%750718563651944518%' I want to get…
I have a table name ar for column operation in it I can allow only specific values ('C', 'R', 'RE', 'M', 'P'). I have added a check constraint for it. Requirement: I need to insert 1 million records in the…
I have the same issue listed in this SO question, but I have tried the solution and I am getting a SQL error 1288- I'm thinking I am poorly translating SQL server to SQL or this method has been deprecated.…
I'm using PostgreSQL and I have a table with the following columns: id, distance, and length. I want to order the table by distance and create a new column called cum_length using a window function. I also want to filter…
This is my table id c_id number 3444 34 3377752 3446 35 3473747 3447 35 3532061 3454 37 3379243 3455 38 3464467 3456 38 3377493 I want to create a table which is show me not repeated value in a…
PostgreSQL 15.0 I want to make a query that concats two different columns into one. Desired outcome I showed in the exapmle (it's not a real one but it would be useful to understand on this example). I've used CONCAT…
Let's say I have a table: name number date name1 91104 '2022-12-01' name2 11161 '2022-12-02' I am writing these queries: select count(name) from table where created_at between '2022-12-01' and '2022-12-10' and terminal_id like '911%' select count(name) from table where created_at…
Artist Points Notorious BIG 34 Notorious BIG feat. blah blah 42 2pac 20 2pac feat. Dr. Dre 30 I would like to group and sum by Artist for a table to look like so: Artist Points Notorious BIG 76 2pac…