I am working with a NBA script in MySQL and I have to find out who is the shortest player in database. I am using feet as measurement and after executing the query i found out that the player the…
The tables in the query are not designed or controlled by me. Please don't tell me to change the table structure because it is outside my scope. using "PostgreSQL 11.16 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat…
I'm having great difficulty writing this query and cannot find any answers online which could be applied to my problem. I have a couple of tables which looks similar to the below with. Each purchase date corresponds with an item…
I have a SQL databases of users forms, and want to set up some routine or maybe even PHP that will automatically delete empty rows which looks like this: Column1=(Name=John Surname=Doe) | Column2=(Name=John Surname=) | Column3=(Name=John Surname=Doe) In this case…
I am starting to learn SQL and I had a question. I am running the following query: SELECT ProductName FROM Products WHERE ProductID =ALL ( SELECT ProductID FROM OrderDetails WHERE Quantity < 0 ) order by ProductID; Why does this…
I have a column which type is JSON but it contains JSON strings like this: "{"a":1,"b":2,"c":3}" I want to update the values in the column with proper JSON objects without the quotes and escapes like this: {"a":1,"b":2,"c":3} I've tried the…
I'm confused what is the relationship bewteen customer and a order. Most of websites says its One to many because One customer can place many order. If we see physically its many to many because there is customer and there…
I have been trying to accomplish an automatic update of a table based on a column value. Here is the example. The idea is that the user will enter their phone, but not their country like this: mobile_phone country '51682815'…
I got this SCD table: start_date end_date partition 2022-03-08 15:35:09.856 2022-03-09 14:57:36.610 1 2022-03-09 14:57:36.610 2022-05-18 13:26:31.195 2 2022-05-18 13:26:31.195 2022-08-02 10:12:02.441 2 2022-08-02 10:12:02.441 2022-09-01 11:10:01.019 2 2022-09-01 11:10:01.019 2022-09-01 11:10:20.777 1 2022-09-01 11:10:20.777 2022-09-01 11:21:26.526 1 I would…
I have a table called country that has 2 columns: orderid, country_code. I need to do the following CASE WHEN: SELECT CASE WHEN country_code IN ('PT','IT','ES','PL','AD') THEN 'SWE' WHEN country_code IN ('MD','BG','BA','SI','HR','ME','RO','RS') THEN 'SEE' WHEN country_code IN ('CI','GH','MA','NG','UG','KE','TN') THEN 'AFRICA'…