Microsoft Microsoft Interview Question 07

Multi-Product
Users

Find users who used more than 2 different products.

Table Schema

Inspect
Table

interactive

Column	Type
user_id	integer
product_name	varchar

Sample Data

Sample Input: product_usage

Expected Output

user_id
101

SQL Editor

Waiting for query

user_id
101

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
FROM product_usage
GROUP BY user_id
HAVING COUNT(DISTINCT product_name) > 2;

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.