Budget Totals Across Departments

Summarise the yearly budgets in departments in a single row: total_budget (the SUM), smallest_budget (the MIN) and largest_budget (the MAX). Include the closed Fine Arts department: its budget is still a real number.

Expected result:

+--------------+-----------------+----------------+
| total_budget | smallest_budget | largest_budget |
+--------------+-----------------+----------------+
|      5430000 |          310000 |        1480000 |
+--------------+-----------------+----------------+
1 row

Hints3 available

Topics:

Aggregates & GROUP BY

Code Editor

Tab to indent (Esc then Tab to move on) · Ctrl+Enter to run · Ctrl+Space to expand shortcuts (sel, ins, desc)

Results

Run your SQL to see every statement's output here, then how it compares with the expected answer.

Not sure what is in a table? SHOW TABLES lists them and DESCRIBE students shows the columns — or open the database browser on the left.