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…