Questions

1. What character is required at the end of all SQL statements?
2. What two clauses are required to select data from a single table?
3. Why should you avoid using SELECT * in a query?
4. What does the WHERE clause do to your query results?
5. What two wildcard operators can you use with LIKE?
6. What does an ORDER BY clause do to your query results?
7. What options do you have for sorting results in your ORDER BY clause?
8. What SQL clause can you use to see the explanation of your query, and what indexes will it use?
9. How do you add an index to an existing table?
10. How do you see the explanation of a query plan using MySQL Workbench?