I am using json_build_object to build a json object using other columns: json_build_object(value1, qty1, value2, qty2, value3, qty3) Every pair (value, qty) go together. I only want the json object to contain the pairs that don't have an empty value.…
I want to count all users that switch from ADVANCED plan to BASIC every month. So, the table plans contain the following data: id userId plan_name start_date 1 20 ADVANCED 2023-06-30 15:07:10.211 2 20 ADVANCED 2023-06-05 12:05:14.289 3 40 BASIC…
I have the following table in PostgresSQL, and I would like to find a function or logic to store the result of the first row in a new column to be used in the second row and so on. The…
lets say i have a table called employee that stores employee data emp_id emp_data 1 xxx 2 xxx Now lets say i want to delete an employee, if there exists any other entries of this employee's Id pointing to this…
I am facing an issue with a moderately simple-looking SELECT SQL Query. My requirement: For One specific company, if there are multiple records with the same date, I want only the first record of that date, not all from that…
I have a table where in a column there are titles. I would like to run a query in PostgreSQL, which helps me to select those titles that contain a particular word. (e.g. select every title that contains 'You', so…
Given a column with json objects, how to sum them based on the keys using sql? {"A": 10, "B": -5} {"A": 20} {"A": -15, "B": -5} {"A": -10, "C": 77} Result: {"A": 5, "B": -10, "C": 77}
This would be considered a "new shop open" in that particular month and year. Say company Store123 placed their first order in January, 2023 and it checks if Store123 ordered before that. If the company did not than Store123 would…
I am having table with column registration year with values like '2017-2019' and '2014-2016. If my input value is 2018 then what will be my SQL query to get that record which is in between '2017-2019'. id registration_year 1 2014-2016…
i have two table like this: phones id name price 1 a20 100 2 a30 200 models: id phone_id model 1 1 a20-128GB 2 1 a20-256GB 3 2 a30-128GB 4 2 a30-256GB 5 2 a30-512GB i want to write SQL…