I receive a syntax error for the following: CREATE OR REPLACE FUNCTION my_function(old_num INTEGER) returns INTEGER language plpgsql AS $$ DECLARE new_num INTEGER; BEGIN CASE WHEN (old_num IN (1, 2, 3, 4)) THEN new_num = 10 WHEN (old_num IN (5,…
Run into sql code with a lot of when: case when callDuration > 0 and callDuration < 30 then 1.4 when callDuration >= 30 and callDuration < 60 then 2.3 when callDuration >= 60 and callDuration < 120 then 3.7…
EDITED: I am trying to CASE a query from my table when a result meets 2 sets of criteria (Flight Time & Tail Number), but I am receiving the wrong result. I only started SQL a few weeks ago for…
I have a database with multiple tables, and I want to add a column to one table that will be populated with different strings based on the contents of another table. Below are the tables of interest. CREATE TABLE Locations(…
I have the function below in Postgres which was working fine. but then I had to add other types, So I tried to add cases to it. But this isn't working as expected. Basically what I am trying to do…
I have a query like this Select a.ordernum, a.region, c.area, a.branchname, a.stagename, sum(case when b.entrydatetime is not null THEN 1 ELSE 0 END) as 'Total Count', sum(case when DATEDIFF(day, b.entrydatetime, GETDATE()) <=1 THEN 1 ELSE 0 END) as 'WITHIN 1…
I'm triying to add quantities of fuels from two tables. Payments table contains data about customers and dates. Fuels table contains data about fuels recharged. I need to add the litres by customer in 3 groups: from yesterday until 46…
I am trying to execute the following statement but it is resulting in error. There is not much to explain the situation here as the query itself is self explanatory. However, I will attach the error below: Query UPDATE swipes…
Im trying to write a query that returns a count depending on the value of a feedback field that ranges from 0-5 (0 meaning that it was not rated). I want: Count of all rows ( anything rated 1 or…
How do I get the SUM of an amount in a CASE WHEN clause? Table real: id name goal year 10 ronaldo 5 2022 10 ronaldo 5 2022 11 messi 5 2022 11 messi 5 2022 10 ronaldo 10 2021…