- What are the lowest and the highest product prices? One row: the lowest first.
- When did the first customer sign up, and when did the latest one sign up? One row: the earliest first.
- Which customer name comes first in alphabetical order?
- What is the highest salary in department 2 (Support)?
- Which product is the cheapest? Show its
name, then itsprice. MIN alone does not give you the name.