rows with same product status in differrnt hour and month
Hi everyone,
I have a table where each row is a product and its status at that time.
im trying to take all the rows that exists on the first day of the month (current month filter) with status (active) at 00:00 and were also exist at the end of the last month with the same status at 23:55 (on the last day of the month)
