I'm not able to quite figure out how to capture the changes over time. I have the following: db<>fiddle CREATE TABLE term_changes (load_id int, merchant_id int, load_date date, terms varchar(50)); INSERT INTO term_changes (load_id, merchant_id, load_date, terms) VALUES (1, 1,…
From the following table of sport matches: id_ p1_id p2_id match_date p1_stat p2_stat 852666 1 2 01/01/1997 1301 249 852842 1 2 13/01/1997 2837 2441 853471 2 1 05/05/1997 1474 952 4760 2 1 25/05/1998 1190 1486 6713 2 1…
I have 2 tables on my db: 1- scheduled services 2- services realized. On 2nd table, I have the value $ received for the service and the date the service was realized. On 1st table, I only have the scheduled…
So basically I have a table where are partners and the dates when then they did their orders. partner_id order_date 1 2022-01-02 1 2022-01-20 2 2022-02-20 4 2022-01-15 4 2022-01-17 4 2022-01-30 And I want to have an information of…
I have the following table: CREATE TABLE IF NOT EXISTS test ( date DATE, value INT ); INSERT INTO test VALUES ( '2022-01-11', NULL), -- Tues ( '2022-01-10', 5), -- Mon ( '2022-01-09', NULL), -- Sun ( '2022-01-08', 6), --…
I would like to make a query similar to this: SELECT time, close - LAG(close) OVER (ORDER BY time) AS "diff" CASE WHEN diff > 0 THEN diff ELSE 0 END AS gain, CASE WHEN diff < 0 THEN diff…
Let's assume there is a table: day amount 1 10 2 20 3 30 I want to know when turnover reached 30, in case above it's happened on 2 day. How to query this in SQL? I guess I have…
I've a sample dataset order_num order_date email product_id 101 2023-06-01 [email protected] 1 101 2023-06-01 [email protected] 2 222 2023-06-02 [email protected] 1 333 2023-06-03 [email protected] 3 434 2023-06-05 [email protected] 3 444 2023-06-01 [email protected] 1 444 2023-06-01 [email protected] 2 677 2023-06-02 [email protected] 3…
I have a MYSQL table with this format: Insurance Date Value A 2020-01-01 2 A 2020-02-01 5 A 2020-03-01 4 A 2020-04-01 6 A 2020-05-01 8 A 2020-06-01 1 A 2020-07-01 3 A 2020-08-01 7 A 2020-09-01 9 A 2020-10-01…
I need to fetch records of last date of each month based on the dates of records in the database table. Now, if I fetch the last dates of each month in my table using following query: SELECT MAX(`date`) AS…