This is an exercise to try out the SQL commands, of Group By and aggregation functions, Sum Avg, Max, Min See the attachment for examples of how to do this: SQLGroupBY.doc Referring to the file ( you have worked with already) Ch4Ch5VeggieDatabaseA6.1DBGarden.doc 0. Find the overall average days to harvest 1. Find the Max overall days to harvest as well as the Min 1. Find the Average days to harvest, grouping by veggie name 2. Do this for max, min days to harvest grouping by veggie name. 3. Find the Average days to harvest, group by season. Show your SQL code , embed it in a .doc and submit. Here is my code so far
This is an exercise to try out the SQL commands, of Group By and aggregation functions, Sum Avg,
Max, Min
See the attachment for examples of how to do this:
SQLGroupBY.doc
Referring to the file ( you have worked with already)
Ch4Ch5VeggieDatabaseA6.1DBGarden.doc
0. Find the overall average days to harvest
1. Find the Max overall days to harvest as well as the Min
1. Find the Average days to harvest, grouping by veggie name
2. Do this for max, min days to harvest grouping by veggie name.
3. Find the Average days to harvest, group by season.
Show your SQL code , embed it in a .doc and submit.
Here is my code so far