I want to count how much NULL data gets to the row with the contents of "resuss" Like that: open_date m+ id flag time hibernate 202203 202205 ax1 resuss 1 202203 202209 ax1 resuss 3 202203 202206 ay2 resuss 2…
I want to right-align the last 3 columns of this table which is being generated by SQL (the headers are redacted from the example code below). This is difficult since the data is generated by a FOR XML statement. Because…
What is the SQL query directly for this given use case: I want to get all records in the table that in their fields column which is of type text has pageTitle containing a specific string Table structure: This query…
I have 3 columns as user_id, start_date, end_date. as an example; user_id start_date end_date 1 2022-07-30 2025-07-30 2 2022-05-25 2027-05-25 I want to create rows based on start_date and end_date with yearly laps on the same date. so it should…
How to query result as Expect Count with Sqlstatement ID StuId IsDone ExpectCount 11111 q-01 false 1 11111 q-02 false 2 11111 q-03 false 3 11111 q-02 true 2 11111 q-04 false 3 22222 q-04 false 2 11111 q-01 true…
I have the following data. ID heade 100 blue 100 black 100 orange 101 brown 101 green 102 green 102 white 102 yellow 103 yellow 103 blue Intended results: If I select blue, I want to get 100 and 103.…
I have a table of Outcodes (in the UK, the first part of postcodes/zipcode) for example id,outcode 1, AB1 2, AB2... and so on 27, AL1 28, AL2...and so on 52, B1 52, B2 52, B3 61, BA1 etc. I…
I have a members table with four columns. table members.tbl_member as U { member_id int [pk, increment] date_created timestamp [not null, default: `CURRENT_DATE`] date_modified timestamp [not null, default: `CURRENT_DATE`] date_security timestamp [not null, default: `CURRENT_DATE`] } (create script from DbDiagram)…
I have three tables: A(id varchar(36) pk, c_id varchar(36)) with 1.2M rows B(id varchar(36) pk, c_id varchar(36)) with 0.6M rows C(id varchar(36) pk, "number" varchar(128), "status" varchar(255)) with 5.4M rows id is UUID string, "number" is 12 symbols long string,…
I'm working on MySQL 8.0 and I wanted to extract characters from my data. There are variations within the same product such as flavors, prices including shipping or not, size, etc. The data includes the following products. Product Total Organic…