1. Learn
    2. /
  2. Courses
    3. /
  3. Applying SQL to Real-World Problems

Exercise

Fix this query - intent

Using the four opportunities you've identified you will now clarify the intent of this query, one step at a time.

SELECT x1.customer_id, x1.rental_date, x1.return_date 
FROM rental x1
JOIN inventory x2
    ON x1.inventory_id = x2.inventory_id
JOIN film x3
    ON x2.film_id = x3.film_id
WHERE x3.length < 90;

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Use single letter aliases to help clarify the table source (e.g. x1 -> r).

Note: Using x1 -> ren would be appropriate as well, but for this exercise please stick to single letter aliases.