8.5 Where and Having

(slide#9) Example: List each department and its total SKUs, excluding SKU 302000 from the total. Sort the list by the sku count in descending order

TABLE8.12: 3 records
department Dept_SKU_Count_no302000
Water Sports 4
Camping 2
Climbing 1

(slide#11) Exercise: List the departments that has more than one SKU which is not 302000.

TABLE8.13: 2 records
department Dept_SKU_Count2_no302000
Water Sports 4
Camping 2