End of Summer - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Summary
15. Exercise 1

Instruction

In this quiz, we're going to use a table named fruit_harvest. It has the following columns:

  • id – the ID of the harvest.
  • site – the ID of the harvest site.
  • year – the year of the harvest.
  • weather – either Fair or Poor. There are two harvests yearly, one in the high season (fair weather) and another in the low season (poor weather).
  • amount – the amount of fruit harvested.

All right, let's take a look at the first question.

Exercise

Show the average amount of fruit harvested for the following grouping sets:

  1. site and year
  2. weather

Show the following columns in the query result: site, year, weather, and avg_amount. Replace all NULLs in the site and weather columns with the word ALL.