UdemySQLbootcamp

general_challenge.sql

SELECT COUNT(amount) FROM payment WHERE amount > 5.00;
SELECT COUNT(*) FROM payment WHERE amount > 5.00;

SELECT COUNT(*) FROM actor WHERE first_name LIKE 'P%';

SELECT DISTINCT(COUNT(district)) FROM address;

SELECT DISTINCT(district) FROM address;

SELECT COUNT(*) FROM film WHERE rating = 'R' AND replacement_cost BETWEEN 5 AND 15;

SELECT COUNT(*) FROM film WHERE title LIKE '%Truman%';

SELECT title FROM film WHERE title LIKE '%Truman%';