Write February Resource Usage Query
Company: Akuna Capital
Role: Data Engineer
Category: Software Engineering Fundamentals
Difficulty: medium
Interview Round: Take-home Project
You have two database tables:
- `cpu_metrics(application_id, dt, usage_percentage)`
- `memory_metrics(application_id, dt, usage_percentage)`
Each row records the resource usage percentage for one application on a given date.
Write a SQL query that returns, for February 2024 only, the applications whose average CPU usage or average memory usage is greater than `50`.
The output should contain:
- `type`: either `CPU` or `Memory`
- `application_id`
- `avg_usage`: the average usage percentage rounded to 2 decimal places
Return CPU and memory results in the same result set. Order the final output by `application_id`, then by `type`.
Quick Answer: This question evaluates SQL skills for aggregating time-series metrics, date-range filtering, rounding/formatting results, and combining multiple metric sources into a unified result set, reflecting data-processing competency within Software Engineering Fundamentals and Data Engineering.