11.4 MIN and MAX for Dates and Amounts

Example 1 · dataset: raja_coffee

SELECT MIN(order_date) AS first_day,
       MAX(order_date) AS last_day,
       MIN(amount_inr) AS min_inr,
       MAX(amount_inr) AS max_inr
FROM orders;

Output

Meaning. Date span and amount span for coffee orders.

Example 2 · dataset: interview_mini

SELECT MIN(amount_eur) AS min_eur, MAX(amount_eur) AS max_eur
FROM tickets;

Output

Meaning. MIN/MAX skip NULL amount_eur rows for those columns.