I have a sample table where I have written Case statement. where I'm not able to write the proper syntax. SELECT case when SECTION = 'A' then case WHEN (SECTION ='A' AND ROLE = ROLENUMBER) THEN 'GOOD' ELSE 'BAD' end…
I'm struggling with replacing value in my wordpress database. I want to change status from "sent" to "completed" in statuses that are related to termins from the past. This is sql which finds what I need: SELECT pm1.meta_value AS Status,…
I am trying to create a visible product list on html. I have gotten it to the point where I had all the products and details showing and a submit button with text box for search at the top that…
My goal is to calculate the interval between two date with and without Saturday and Sunday. If my table look like this : entity_id time_c next_time_c 1 '2022-06-09 15:39:00' '2023-02-27 15:09:48' 2 '2023-03-06 11:17:12' '2023-03-06 11:17:14' I'm able to calculate…
I am having a table as follows. entity_id|effective_date|value| A |2023-09-09 |234 | A |2023-09-06 |345 | B |2023-09-02 |341 | C |2023-09-01 |347 | I want to find all unique entity IDs with the maximum effective date and their respective…
I am trying to write a query for select a specific year data from data table, but I am getting an error. I am trying to reach the average of the hourly fee for cars parked in 2022. I wrote…
I want to write a SQL query that will find all the number of records in a table that are associated with the same child records. For example: In the dataset below parents 1001 and 1003 are associated with the…
I have following table no status amount 1 2 10000 2 3 10000 3 2 1000 4 2 -11000 I got running some by using following query. SELECT main.no , main.status , main.amount , SUM(main.amount) OVER ( ORDER BY main.no…
My SQL knowledge is a bit more limited than I'd like to admit. What I'm attempting to do is query a single table. In that table I want to return and group items with the same "name" (column), but only…
So I have a table 'A' with has column of numerical values of 12 digits, now there is another table 'B' which has only first 6 digits of the same numerical value, I want to join both the tables using…