DB-TASK-002
SELECT title, rental_rate
FROM film
WHERE rental_rate > 3;SELECT title, rental_rate, replacement_cost
FROM film
WHERE rental_rate > 3 AND replacement_cost < 20;SELECT title, rating, rental_rate
FROM film
WHERE rating = 'PG' OR rental_rate = 0.99;SELECT title, rental_rate
FROM film
ORDER BY rental_rate DESC
LIMIT 10;SELECT title, rental_rate
FROM film
ORDER BY rental_rate ASC
OFFSET 5 FETCH NEXT 3 ROWS ONLY;
SELECT title, rental_rate
FROM film
ORDER BY rental_rate ASC
OFFSET 5 LIMIT 3;
SELECT title, rental_duration
FROM film
WHERE rental_duration BETWEEN 3 AND 7;SELECT title
FROM film
WHERE title LIKE 'A%e';SELECT first_name, last_name
FROM customer
WHERE email IS NULL;FROM film
WHERE release_year = 2006
AND rental_rate IN (2.99, 3.99)
AND title LIKE 'S%'
LIMIT 5;SELECT first_name, last_name
FROM customer
ORDER BY last_name
LIMIT 10 OFFSET 20;SELECT title, replacement_cost
FROM film
ORDER BY replacement_cost DESC
OFFSET 1 FETCH NEXT 5 ROWS ONLY;SELECT rental_id, rental_date, customer_id
FROM rental
WHERE rental_date BETWEEN '2005-05-01' AND '2005-06-01';SELECT first_name, last_name
FROM actor
WHERE last_name LIKE '%man%';SELECT title
FROM film
WHERE special_features IS NULL;SELECT title, rental_duration
FROM film
WHERE rental_duration > 7;SELECT title, rental_rate, rating
FROM film
WHERE rental_rate IN (2.99, 4.99)
AND rating = 'R'
AND title LIKE '%L%'
LIMIT 10;Bonus Q/A
Last updated