Skip to main content
All Problems
medium0% acceptance

Products with Average Rating and Review Count

Create a product report showing each product's name, price, number of reviews, and average rating. Include products with zero reviews (show 0 for count and NULL for average). Sort by average rating descending, with NULLs last.

Schema

🔑idINT
nameTEXT
🔗category_idINT
priceREAL
costREAL
stock_quantityINT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute