my-guitar-shop-database-exersices/Exercise_2.1.sql

SELECT c.category_name as Category,
p.product_name as Product, 
p.list_price as Price 
FROM
products p
INNER JOIN
categories c ON p.category_id = c.category_id
ORDER BY category_name, product_name ASC;