Skip to main content
All Problems
easy0% acceptance

List All Products

The product catalog team needs a quick inventory snapshot. Write a query that retrieves the name and price of every product in the store, sorted alphabetically by product name.

Schema

🔑idINT
nameTEXT
🔗category_idINT
priceREAL
costREAL
stock_quantityINT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute