Here is the code of the (My)SQL function (it works outside of the function), but I can't manage to save it as a function for further reuse... This is an example of the working query: SELECT ( SUM(Items_Available * Store_Sales)…
For a wordpress website that I am developing I am trying to order a list of objects in SQL by price and would like to have the order descending but have prices that are not numbers (Price on demand for…
This is my input table but i want to get this table Explaination: I want to subtract value of segmeted 14/10/22 - 7/10/22 that means (28930-28799) how could i get this kindly help me to figure it out. I cant…
Write an SQL query to report the patient_id, patient_name all conditions of patients who have Type I Diabetes. Type I Diabetes always starts with DIAB1 prefix. +--------------+---------+ | Column Name | Type | +--------------+---------+ | patient_id | int | |…
I am looking to replace the NULL values that occur as a result of a SQL JOIN statement, with 'N/A'. I have tried to set the default value of both related columns from both tables to N/A, however, every time…
I have a simple stored procedure with comma separated input params. I will send Database Names in Json or Comma separated values. Like DB1,DB2,DB3 etc..; When ever I send that parameter will be loading that table in each of the…
I have the following table : city state numOrder date deadlineDate NY NY 111 2022/11/05 2022/11/06 LA CA 222 2022/11/01 2022/10/01 SD CA 333 2022/05/05 2022/11/06 LA CA 444 2022/11/01 2022/05/01 I need to calculate the number of orders placed…
I have 2 tables in a database, users and users_removed with columns "id(primary key), email(unique), password" and "id, user_id(foreign key (user_id) references users(id)" respectively. When a user registers the users table gets the data accordingly. And when the user wants…
Via SQL, I'm trying to get from this: id group_id session_id field_label field_value sent_at 1 frosted flakes blue bowl first_name Bob 2022-11-05 18:18:19.093 2 frosted flakes blue bowl first_name Bobby 2022-11-05 18:17:31.274 3 frosted flakes blue bowl last_name Brown 2022-11-05…
I have a table with the following structure: name | version | processed | processing | updated | ref_time ------+---------+-----------+------------+----------+---------- abc | 1 | t | f | 27794395 | 27794160 def | 1 | t | f | 27794395…