SELECT
Also known as · SELECT Clauses
Chooses which columns or expressions appear in the output.
SELECT title, rental_rate
FROM film
When to use
Starts every query in the course, for example PS 03 and PS 04. It is evaluated after WHERE, GROUP BY and HAVING, so an alias defined in SELECT cannot be used in WHERE.
See PS 03.