We just learned how to query data from a database using SQL. We also learned how to filter queries to make the information more specific and useful.
SELECTis the clause we use every time we want to query information from a database.
ASrenames a column or table.
DISTINCTreturn unique values.
WHEREis a popular command that lets you filter the results of the query based on conditions that you specify.
BETWEENare special operators.
ORcombines multiple conditions.
ORDER BYsorts the result.
LIMITspecifies the maximum number of rows that the query will return.
CASEcreates different outputs.
Feel free to experiment a bit more with the
movies table before moving on!