Microsoft Microsoft Azure Interview Question 05

Cloud
Resource
Usage

Find the top 3 users consuming the most compute hours.

Table Schema

Inspect
Table

interactive

Sample Data

Sample Input: cloud_usage

usage_id	user_id	resource_type	compute_hours
1	101	VM	20
2	102	VM	30
3	101	Storage	10
4	103	VM	50
5	104	VM	40
6	101	VM	25

Expected Output

SQL Editor

Waiting for query

Hints

Hint 01: Identify the grouping level required by the output.

Hint 02: Aggregate with COUNT, SUM, AVG, or a window function as needed.

Hint 03: Filter after aggregation with HAVING or after ranking with an outer query.

Solution

Solution is locked until you decide to reveal it. Try the editor first, then open this when you want the reference answer.

SELECT user_id, SUM(compute_hours) AS total_compute_hours
FROM cloud_usage
GROUP BY user_id
ORDER BY total_compute_hours DESC
LIMIT 3;

Explanation

Read the expected output columns to determine the final grain.

Aggregate or rank the input rows to calculate the requested metric.

Filter, sort, and alias the final columns to match the output.