Find products priced above category average

Find products priced above category average

Hard SQL Subqueries 20 views
Explanation Complexity

Problem Statement

Return products where price is greater than average price of their category.

Input Format

SQL query

Output Format

Result set

Example

Products(category, price)
Product list

Constraints

Correlated subquery

Input / Output Format

Input Format
SQL query
Output Format
Result set
Constraints
Correlated subquery

Examples

Input:
Products(category, price)
Output:
Product list

Example Solution (Public)

SQL 
SELECT p.product_id, p.name, p.price FROM Products p WHERE p.price > (SELECT AVG(x.price) FROM Products x WHERE x.category = p.category);

Official Solution Code

SELECT p.product_id, p.name, p.price FROM Products p WHERE p.price > (SELECT AVG(x.price) FROM Products x WHERE x.category = p.category);
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.