I have two tables Account table id | account_no ----------------------- 1 | 111 2 | 222 Account details id | act_id (fk) | amount | created_dt_ | created_by ------------------------------------------------ 1 | 1 | 10 | 2022-10-30 | SYSTEM 2 |…
I have a table with payment history payments: id consumer_id amount created_at 1 1 30 2021-05-11 13:01:36 2 1 -10 2021-05-12 14:01:36 3 1 -2.50 2021-05-13 13:01:36 4 1 -4.50 2021-05-14 13:01:36 5 1 20 2021-05-15 13:01:36 In final result…
I have a repayment table that looks like this below, cus_id due_date principal disbursed_date 1 01-01-2022 10 01-11-2021 1 01-02-2022 10 01-11-2021 1 01-03-2022 10 01-11-2021 2 15-03-2022 20 15-02-2022 1 01-04-2022 10 01-11-2021 3 01-04-2022 15 20-03-2022 2 15-04-2022…
I have a table Table name - commands id name status group_id id - number name - string status - 0 or 1 group_id - number I need to sort as follows: for all elements with the same group_id I…
I am trying to create a cumulative count for unique customers only by the month they purchased. The example Table is: customer_email cohortMonth [email protected] 10/2019 [email protected] 10/2019 [email protected] 10/2019 [email protected] 11/2019 [email protected] 11/2019 [email protected] 12/2019 The output I am looking…
I have this SQL query: SELECT users.id, users.name, users.avatar, MAX(messages.created_at) max_created_at, MAX(messages.body) FILTER (WHERE messages.created_at = MAX(messages.created_at)) last_message, CASE WHEN(COUNT(messages.is_read) FILTER (WHERE is_read = false AND messages.from_id != 14) = 0) THEN true ELSE false END is_read, COUNT(messages.is_read) FILTER (WHERE…
I have a query that orders the result by a specific none-unique column. Now I want to get the first N rows after a specific ID (the primary key). I have a table similar to this: ID Size 0 3…
I'm having trouble manipulating certain information in a Select. I've tried a few ways but with no positive result. Select: select cpri.sequential, cpri.id, coalesce(sum(pdr.something), 0) something, ... from cpri inner join cpr on cpr.id = cpri.id left join pdr on…
i'm knew with window function I have two tables which i join together (One user could have many project). Each Project has their own date (date_project) I need query all users with thier projects and add a column in the…
Let's say I have the following data set: ID Identifier Admission_Date Release_Date 234 2 5/1/22 5/5/22 234 1 4/25/22 4/30/22 234 2 4/20/22 4/24/22 234 2 4/15/22 4/18/22 789 1 7/15/22 7/19/22 789 2 7/8/22 7/14/22 789 2 7/1/22 7/5/22…