SQL built-in functions
Answer the following questions:
1. What is the simplest SQL retrieval?
2. What is the purpose of the Where clause when using SELECT?
3. What are data types and why are they important?
4. Provide an example of the GROUP by clause, when would you use this clause?
5. What is an aggregate function (provide 4)? How are they used?
6. Provide example using the COUNT() function
7. How is a field name qualified? How is this used when using a JOIN command, why is it important?
8. What are the three update commands in SQL?
9. What method allows you to re-order the presentation data?
10. How are SQL built-in functions used?