Instructions
Read the following and write the SQL that would provide the data to answer the question. Turn in the SQL. I don't necessarily need the results unless I specifically request it.
1. List all the persons.
2. List all the persons in alphabetical order by last name.
3. List all the persons in alphabetical order by last name and in reverse order by first name.
4. List all the addresses where the city is shoreline.
5. List all the addresses that are not in Seattle.
6. List all the donations greater that $1000.
7. List all the donations less than $100.
8. List the unique personkeys of those given grants.
9. Show each donation amount and what 10% of that donation would be.
10. Show all grants for service type 3.
11. List all the grants for service 3 or service 5
12. List all the persons whose last name starts with "m"
13. List all the persons whose last name has the letters 'an" somewhere in the name.
14. List all the donations between Feb 1 2010, and Feb 28 2010.
15. List all the Employees who have no (null) dependents
16. List the donations made after March 1 2010