SQL SAKILA Gruop by

SELECT

INSERT

UPDATE

DELETE

SELECT UNIQUE title FROM film;

SELECT title FROM film;

SELECT DISTINCT title FROM film;

SELECT DIFFERENT title FROM film;

CAPITALIZE()

UPPER()

TEXT_UPPER()

TO_UPPER()

SELECT HIGHEST(rental_rate) FROM film;

SELECT BIGGEST(rental_rate) FROM film;

SELECT MAX(rental_rate) FROM film;

SELECT rental_rate FROM film ORDER BY rental_rate DESC LIMIT 1;

SELECT rating, COUNT(*) FROM film SORT BY rating;

SELECT rating, COUNT(*) FROM film GROUP BY rating;

SELECT rating, COUNT(*) FROM film ORDER BY rating;

SELECT rating FROM film GROUP COUNT;

SELECT * FROM customer SORT BY last_name;

SELECT * FROM customer ORDER BY last_name ASC;

SELECT * FROM customer GROUP BY last_name;

SELECT * FROM customer ORDER last_name;

SELECT * FROM film WHERE rental_rate = (2 TO 5);

SELECT * FROM film WHERE rental_rate BETWEEN 2 AND 5;

SELECT * FROM film WHERE rental_rate >= 2 AND rental_rate <= 5;

SELECT * FROM film HAVING rental_rate >= 2 AND rental_rate <= 5;

SELECT COUNT(*) FROM customer WHERE EXISTS (SELECT * FROM rental);

SELECT COUNT(DISTINCT customer_id) FROM customer;

SELECT COUNT(DISTINCT customer_id) FROM rental;

SELECT customer_id FROM rental GROUP BY customer_id;