8.4 Having Clause
- How many SKUs is each buyer responsible for?
| 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)
| department | buyer | Dept_Buyer_SKU_Count |
|---|---|---|
| Camping | Cindy Lo | 2 |
| Climbing | Jerry Martin | 2 |
| Water Sports | Pete Hansen | 2 |
| Water Sports | Nancy Meyers | 2 |