A number of different queries that will allow the user to extract useful information from the database. When developing your queries, you should develop different queries to fulfil the following criteria:
Use of aggregate functions such as COUNT, SUM, AVG, MIN, MAX
Use of clauses such as GROUP BY and ORDER BY
Use of JOINS to retrieve data from a number of related tables
Use of calculated and concatenated fields with aliases
Ability to INSERT, UPDATE, and DELETE records
You should ensure that you use a sufficient number of queries to use data from all the tables in your database. Your queries should be complex enough to demonstrate your understanding of SQL.
A number of different queries that will allow the user to extract useful information from the database. When developing your queries, you should develop different queries to fulfil the following criteria:
Use of aggregate functions such as COUNT, SUM, AVG, MIN, MAX
Use of clauses such as GROUP BY and ORDER BY
Use of JOINS to retrieve data from a number of related tables
Use of calculated and concatenated fields with aliases
Ability to INSERT, UPDATE, and DELETE records
You should ensure that you use a sufficient number of queries to use data from all the tables in your database. Your queries should be complex enough to demonstrate your understanding of SQL.