Part A. Reports are generated using queries to a database. The SELECT statement is used to retrieve data from one or many tables in a database. Just as in other programming languages, understanding the syntax of a select statement is key. Let's first discuss the key clauses in a SELECT statement and the purpose of each.

Part B. Is it possible to next SELECT statements? Why would we want to do this?

Part C. Give an example statement where you would ORDER BY two columns?

SQL