SQL in Access Assignment:

This assignment is to be done entirely using SQL – please copy the SQL and paste it to a word document after you write it because you do not want changes to your SQL. You should turn in the database and the word document.

Use the Credit Union database that you created last week. Add these queries and then resend me the database with the queries included. Please save them as ASGN3NO1, ASGN3NO2 etc.

1. Do a query that involves a group function such as AVG, SUM, COUNT, MAX, MIN. Use it with the GROUP BY clause.
2. Do a second query that involves a group function with the GROUP BY clause.
3. Do a query that involves a group function that excludes records prior to forming the group.
4. Do a query that involves a group function that excludes a group after it has been formed.
5. Do an update that allows the user to key in the change to made and the record to be changed.
6. Do a simple subquery using an operator such as >, <, =.
7. Do a subquery using IN.
8. Explain the difference between when you can use >, <, = and when you must use IN.
9. Do a subquery that uses one table for the inner subquery and a different table for the outer subquery.
10. Do a subquery that uses a group function in the inner subquery.
11. Do a query involving two subqueries in an AND relationship.
12. Do a query involving two subqueries in an OR relationship.
13. Do a subquery using ANY.
14. Do a subquery using ALL.
15. Do a query with a subquery that uses the HAVING clause.