Departments With Budget Over $300k
Every team at Kestrel Labs funded above $300,000 a year has to send someone to the quarterly finance review. The CFO's assistant is writing the invitations and wants the team names with the figure beside each one, so the email can say why the team is on the list.
Four teams is small enough to read off the page, but the review runs every quarter and the budgets get revised in between, so the assistant wants something she can re-run rather than a list she has to re-read. The rule is also strict: a team funded at exactly $300,000 stays home.
departments — one row per team. budget is the annual budget in whole dollars.
| id | name | budget |
|---|---|---|
| 1 | Engineering | 900000 |
| 2 | Sales | 400000 |
| 3 | Marketing | 250000 |
| 4 | Data | 500000 |
The table already exists in the database — there is nothing to create or load.
Task: Write a query returning two columns, name and budget, for every team funded above $300,000, sorted alphabetically by name.
Example output — shape only; the figures below are invented, not this data's answer.
| name | budget |
|---|---|
| Facilities | 620000 |
| Legal | 480000 |
| Research | 350000 |
Sign in to solve this problem
Reading problems is free for everyone — solving them (Run, Submit, and tracking what you've solved) needs an account.
Sign in