Topic: SQL / Database Management

Given the following schema, find all departments that sell at least one item costing greater than $100.

Items(id: string, description: string, dept: string, count: int, price: float)

Group of answer choices

1. SELECT dept, MAX(price) FROM Items GROUP BY dept

2. SELECT dept, MAX(price) AS maxprice FROM Items GROUP BY dept, maxprice > 100

3. SELECT dept, SUM(price) FROM Items GROUP BY dept HAVING SUM(price) > 100

4. SELECT dept, MAX(price) AS maxprice FROM Items WHERE maxprice > 100 GROUP BY dept

5. SELECT dept, MAX(price) AS maxprice FROM Items GROUP BY dept HAVING maxprice > 100