Practice SQL Window Functions | Xorthax's Trading Post

Tables Used

products

Column	Type
productid	bigint
name	text
description	text
category	text
price	double precision
supplierid	bigint
stockquantity	bigint

Expected Output

Column
category
productname
price
lowestcategoryprice

9. Lowest Deals in the Galaxy

Identify the lowest-priced product per category and compare it to the current price.

Xorthax wants to identify the lowest price for each product category sold at his trading post. Write a query to display the minimum price for each category, along with the product name and its current price.

Write Your Query