Solution:Step 1: Understand the subqueryThe subquery calculates total order amount per user by joining users and orders and grouping by user name.Step 2: Apply the outer WHERE filterThe outer query filters to only include users whose total order amount is greater than 100.Final Answer:Names of users

[Solved] Given the tables:users(id, name)orders(id, user_id, amount)What will this query return?SELECT sub.name, sub.total FROM (SELECT u.name, SUM(o.amount) AS total FROM users u JOIN orders o ON u.id = o.... | SQL

SQL - Subqueries

Given the tables:
users(id, name)
orders(id, user_id, amount)
What will this query return?

SELECT sub.name, sub.total FROM (SELECT u.name, SUM(o.amount) AS total FROM users u JOIN orders o ON u.id = o.user_id GROUP BY u.name) AS sub WHERE sub.total > 100;

ANames of users with total order amount greater than 100

BAll users with their total order amount

CSyntax error due to missing alias

DEmpty result because no users have orders

Step-by-Step Solution

Solution:

Step 1: Understand the subquery
The subquery calculates total order amount per user by joining users and orders and grouping by user name.
Step 2: Apply the outer WHERE filter
The outer query filters to only include users whose total order amount is greater than 100.
Final Answer:
Names of users with total order amount greater than 100 -> Option A
Quick Check:
Subquery sums orders; outer filters total > 100 [OK]

Quick Trick: Subquery calculates totals; outer query filters results [OK]

Common Mistakes:

MISTAKES

Ignoring the WHERE filter on total
Assuming all users are returned
Confusing alias usage

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given the tables:

Step 1: Understand the subquery

Step 2: Apply the outer WHERE filter

Final Answer:

Quick Check:

Want More Practice?