11.4 तारीख आणि रकमेसाठी MIN आणि MAX

उदाहरण 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. कॉफी ऑर्डर्सची तारीख आणि रक्कम श्रेणी.

उदाहरण 2 · dataset: interview_mini

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

Output

Meaning. त्या कॉलमसाठी MIN/MAX NULL amount_eur वगळतात.