Instructions
Read the following and write the SQL that would provide the data to answer the question. For each of these use subqueries, even if it seems like it would be easier to use a join. Turn in the SQL. You do not need to turn in the results of the query.
1.Select the grant keys, the grant dates and the grant amount for the maximum grant given
3. Select the last names and first names for each person that recieved the largest grant
4. What services have never been granted.
5. What is the first name and the last name of each donor
5. This one is difficult: Use sub queries to show the montly total of donations, the total of all donations and the percent that each monthly donation is of the total of all donations. The result should look like this:
Month Monthly Total Percent 2 2925.00 17825.00 16.40 3 9350.00 17825.00 52.45 4 5550.00 17825.00 31.13