I have a table with these columns: id, sku, price, date CREATE TABLE price_log ( id int NOT NULL PRIMARY KEY, sku text NOT NULL, date date NOT NULL, price real NOT NULL, CONSTRAINT date_sku UNIQUE (sku,date) ) I want…
I have a string column durationinseconds. I want to take sum(durationinseconds) and make it human-readable as hrs and mins. Example: Total sum of durationinseconds is 54000000300 seconds. Now I want to convert and get it as: 15000000 hrs 5 min…
I want to find the rate of negative and zero profits from a column. I tried to do it using aggregate and subquery but it doesn't seem to work as both method return 0 values. The code is as follows…
is there any way to convert dates in the long-format 'September 21, 2022' to just standard DD/MM/YYYY formats?
I have a table where I save plays for players over a specific game on it. the game has different levels. the player can play the same level multiple times. I need to query that table to count the number…
I have following tables , I would like to distinguish each cols by null or is not null. priority1 priority2 priority3 ... a a null a null null null null null a null a a a null null a a…
I have a central database containing millions of IDs. And I have a group of users (50-100 users), all being able to request extraction of IDs from this big database. Atm what I do is when a user sends a…
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…
I have the following code to pull records from a daterange in PostgreSQL, it works as intended. The "end date" is determined by the "date" column from the last record, and the "start date" is calculated by subtracting a 7-day…
Imagine the following data: I am interested in returning the entries where there is a gap in the data for a particular student, where the category changes from one year to another, or both. So the output that I'm after…