here's a sample from my table in Metabase PostgreSQL: timestamp 2023-01-25T05:00:01+03:00 2023-01-25T05:01:01+03:00 2023-01-25T05:05:01+03:00 2023-01-25T05:13:01+03:00 2023-01-25T05:14:01+03:00 2023-01-25T05:20:01+03:00 2023-01-25T05:24:01+03:00 2023-01-25T05:29:01+03:00 I want to group by 15-minute interval and count events that happen in the interval: timestamp count 2023-01-25T05:00 5 2023-01-25T05:15 3 this…
How to add a subquery to the query to display the last message in the room? Chat rooms id, type(USER_TO_USER, USER_TO_SHOP, USER_TO_PLATFORM), name list of messages room_messages - id, participant_id, text, is_read my query select r.id, r.name from rooms as…
How to optimize requests? Hello there is a chat which consists of the following tables Chat rooms id, type(USER_TO_USER, USER_TO_SHOP, USER_TO_PLATFORM), name Chat Room Members room_participants id, participantType (USER, SHOP, PLATFORM), participant_id list of messages room_messages - id, participant_id, text,…
I have a table called main_table and it has the following records cust_id start_date end_date 10001 2022-12-01 2022-12-30 10001 2023-01-03 2023-02-01 I have another table called penalty_a_type and it has the following records cust_id start_date end_date penalty_a 10001 2022-12-01 2022-12-30…
I using postgres sql.I doing a query to calculate the estimated end date from start date and duration (minutes|hours|days|months|etc). The duration can be in minutes|hours| days|months . i try to use dateif but it work if we know the start…
I have created my first MySQL query to get the minimum LTP by MarketName/SelectionName. It works ok but I'm struggling to work out how to get the rest of the fields from the original table (checktable). I just want the…
I need to store order in which rows were written, but new for every unique value in other column For example: Column A Base index 1 1 1 2 2 1 3 2 2 4 2 3 5 2 4…
I am working on PHP with mysql, Right now i have following two tables,And i want to display minimum value according to collection id,Here is my first table "nft_info" id collection_id name 1 18 abc 2 18 xyz 3 19…
I am working with a table of employees and information in the format (Fname, Lname, Ssn, Bdate, Salary, Dno) Where Dno is the department number the employee works in I am trying to create a query that returns the names…
I run an ASP.NET (C#) Web Forms ecommerce website hosted in Azure as an auto scale-out WebApp, using an AzureSQL database. Each of the 300k product pages displays a significant amount of data that's pulled from the database. Retrieving the…