Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

GROUP BY Extensions in SQL

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.