8.4 Having Clause

  • How many SKUs is each buyer responsible for?
TABLE8.10: 4 records
count(sku)
2
2
2
2
  • List buyers who is responsible for at least two SKUs, in three columns, department, buyer, sku count. Sort buyers by their department names in ascending order. (HAVING)
TABLE8.11: 4 records
department buyer Dept_Buyer_SKU_Count
Camping Cindy Lo 2
Climbing Jerry Martin 2
Water Sports Pete Hansen 2
Water Sports Nancy Meyers 2