I’m trying to figure this out, but it’s driving me insane! How do I calculate in SQL the number of days that are in a specific year between two dates? For example: we have the range date [12/30/2016-01/05/2017]. If I need to find how many days are in 2017 between this range of dates, it would be 5 days. How
I have 2 tables namely Item table with details of item_id, store_id, offer_start_Date and offer_end_date Store table has store_id, day_of_week, store_hours The structure of both tables are follows – 1) Item_Table : Store ID Item ID offer_start_Date offer_end_date NY0001 FMC0001 2021-10-30 2021-11-04 NY0001 FMC0002 2021-11-08 Null NY0002 FMC0003 2021-11-02 2021-11-02 NY0002 FMC0004 2021-09-01 2021-10-10 2) Store Table : Store ID
I have the following table showing when customers bought a certain product. The data I have is CustomerID, Amount, Dat. I am trying to create the column ProductsIn30Days, which represents how many products a customer bought in the range Dat-30 days inclusive the current day. For example, ProductsIn30Days for CustomerID 1 on Dat 25.3.2020 is 7, since the customer bought
I have a table named Items containing a list of items both at grouped level (G) and sub level (L). However I want to see only the sub level (L) data but with the respective Group Name attached to each sublevel. The Grouped item has a start and end number range. The numbers are not +1 for the sub level
I have a table that has a TEXT column that holds IP, IPs or range (for example 126.96.36.199/24). In case of multiple IPs, the IPs will be separated by a @##@ for example 188.8.131.52@##@184.108.40.206 The table with 4 rows: I want to get all the rows that contain the ip 220.127.116.11 or 18.104.22.168, meaning I want to get the first
I have a bunch of timestamps grouped by ID and type in the sample data shown below. I would like to find overlapped time between start_time and end_time columns in seconds for each group of ID and between each lead and follower combinations. I would like to show the overlap time only for the first record of each group which
I am trying to calculate average monthly value of PREMIUM for each POLICY_ID in monthly basis as shown below screenshot. When a customer updates his/her yearly PAYMENT_FREQUENCY to a value different than 12, I need to manually calculate the average monthly value for the PREMIUM. In addition, average monthly PREMIUM amount can be changed in time. For instance, for the
I have a query that looks like this: SELECT DISTINCT p.person_ID ,p.Last_Name ,ISNULL(p.Middle_Initial, ”) AS Middle ,p.First_Name ,sh.Status_from_date ,sh….