Microsoft-style Company ChallengeBeginnerVerified answerSQLite live

Microsoft Products

What Microsoft products are listed in the system?

  • Sorting

Challenge brief

Understand the request

Product Management needs a simple list of all products in the catalog for an internal product overview document.

List all product names from the products table.

Return

  • product_name

Constraints

  • Return every catalog product
  • Order by product ID

Data you will use

Review the relevant tables before deciding how to join, filter, or aggregate them.

products

  • product_idINTEGER
  • product_nameTEXT
  • categoryTEXT

Hints, when you need them

Open one clue at a time so you still do the reasoning.

Hint 1

All product data is in the products table. Just SELECT the product_name column — no WHERE, no JOIN, no GROUP BY.

Hint 2

SELECT product_name FROM products.

Hint 3

Build question 3 from the required result grain: choose the driving table, add only the joins and filters needed for that grain, then apply aggregation and deterministic ordering.

Verified SQL answer

Attempt the problem first, then compare structure and reasoning—not just syntax.

Reveal solution and explanation
SELECT product_name FROM products ORDER BY product_id;

Why this works

Single-table SELECT. No filtering or aggregation. The 4 products span Cloud (Azure), Productivity (Office), Collaboration (Teams), and Business (Dynamics).

Success check

4 products — Microsoft Office, Azure, Teams, Dynamics

Expected result

Use this output to verify values, aliases, ordering, and row count.

product_name
Microsoft Office
Azure
Teams
Dynamics

Learn the concepts behind this answer

Strengthen your understanding with these targeted learning topics:

Continue practicing

Explore related company challenges

SQL Interview Practice →

Return to the complete interview preparation experience.