PostgreSQL version: 15 I have dynamic tables with dynamic columns and I need to calculate some abstract property length. If column is array then I need to use array_length function, if column is string then length. I tried to use…
I'm trying to use a case function with a window function, but the data I'm getting doesn't add up. Everything seems to work, but I'm only receiving "Above Average" for that entire CASE function, so I know something isn't quite…
I am trying some practice SQL problems and I am having trouble with one question. The question wants me to return a table that has [Test ID, Test Name, and Test Difficulty]. The issue is that I have to create…
I want to filer data from my postgres database. i want to use where clause together with postgres case expressions for filtering data in a single query. i want some thing like this logic select *from [my-table-name] where ( CASE…
This SQL request works perfectly: SELECT f.idFile, f.FileName, f.date_file, COUNT(DISTINCT (ligne.numLigne)) AS nbCmde, COUNT(DISTINCT CASE WHEN bl.date_production != "0000-00-00 00:00:00" THEN ligne.numLigne END) AS cmdProd, COUNT(DISTINCT CASE WHEN bl.date_production = "0000-00-00 00:00:00" THEN ligne.numLigne END) AS cmdNonProd, COUNT(DISTINCT CASE WHEN…
I want to write this type query : SELECT CASE WHEN t1.date_closed - t1.created_date < t3.estimated_solution_time_minutes THEN 'не в SL' ELSE 'в SL' END AS result but t1.date_closed and t1.created_date are intervals like this '2023-05-02 11:30', but t3.estimated_solution_time_minutes is integer…
I'm having problems with the case statement in PostgreSQL. Here I want to change the output of the month (number) to text, like January, February, etc. select date_part('month', tanggal) bulan, case when date_part('month', tanggal)= 1 then 'January' when date_part('month', tanggal)…
I'm writing a query where I'm doing a union on several different tables to combine them to make one item. Let's make up an example where I have a table Purchases and a table Leases and I'm creating a new…
I am trying to count the unique values of a position_id while also satisfy another criteria of "true" in another column. I keep getting all values returned since I am counting them. COUNT(DISTINCT CASE WHEN p.position_id IS NOT NULL THEN…
I have a table named sales_data where I have 3 columns (id int, udf varchar(20), date_of_sale datetime). I'm trying to find weekday for the column date_of_sale by adjusting the time to 6 hours, now I have to update the column…