Generate sql query to display product id and product name


Problem

Generate SQL query to display the product ID, product name, category name, and unit price of the highest and lowest paid product(s). Sort the result by category ID and the product ID.

highest paid: the highest unit price
lowest paid: the lowest unit price

Product ID Product Name Category Name Unit Price
-------------- ------------------- --------------------- ------------

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Generate sql query to display product id and product name
Reference No:- TGS03242756

Expected delivery within 24 Hours