Forum

Posted by Pavel, Aug. 8, 2023, 9:20 a.m.

Q32, please, help me to find a mistake

Plese, look at my solution. To me everything seems simple, however, the result is different. Maybe I made a mistake?

WITH rental_inventory AS (
SELECT
R.inventory_id,
I.film_id
  FROM
rental R INNER JOIN inventory I ON R.inventory_id = I.inventory_id
  WHERE
DATE(rental_ts) >= '2020-02-01' AND DATE(rental_ts) <= '2020-02-29'
)
SELECT
count(*)
FROM 
film F LEFT JOIN rental_inventory RI ON F.film_id = RI.inventory_id
WHERE
RI.inventory_id is null


Answers

I haven't gone through this extensively, but you may want to consider a situation where there are multiple copies of a film available.

Right on Mike!

Leon, Oct. 1, 2023, 6:56 p.m.
SQLPad user avatar

Mike (228)

Sept. 9, 2023, 2:53 p.m.