1/3
Looks like no tags are added yet.
COALESCE and NULLIFSELECT
id,
title,
COALESCE (
NULLIF (excerpt, ''),
LEFT (body, 40)
)
FROM
posts;CASE
SELECT
SUM (
CASE
WHEN rental_rate = 0.99 THEN 1
ELSE 0
END
) AS "Economy",
SUM (
CASE
WHEN rental_rate = 2.99 THEN 1
ELSE 0
END
) AS "Mass",
SUM (
CASE
WHEN rental_rate = 4.99 THEN 1
ELSE 0
END
) AS "Premium"
FROM
film;minus 1 day
-- Write your PostgreSQL query statement below
select
w2.id
from
weather w1
join weather w2 on w1.recordDate = w2.recordDate - INTERVAL '1 day'
and w2.temperature > w1.temperature;PARTITION BY with ROW_NUMBERselect
*
from
(
SELECT
Delivery.*,
ROW_NUMBER() OVER (
PARTITION BY customer_id
ORDER BY
order_date
) as n
FROM
Delivery
)
where
n = 1