I have a query for deployment table. There is no data for hotfix column now. I want to show all change count without hotfix and with hotfix for time intervals. Table data: deployTime changeno hotfix 2022-08 aaa 2022-08 bbb 2022-11…
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 have table user: user_id status 1010 1 1010 3 1010 3 1011 5 1011 2 1011 3 1012 3 1012 3 i want to filter user_id with the condition that the number "3" in the status column cannot appear…