All problems

Departments With Budget Over $300k

easySQLFiltering

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

Discussion

Sign in to join the discussion — reading is open to everyone.

Loading comments…