Write a SELECT statement that joins the Categories table to the Products table and returns these columns: category_name, product_name, list_price. Sort the result set by category_name and then by product_name in ascending sequence.

SELECT category_name, product_name, list_priceFROM categories cat INNER JOIN products prON cat.category_id = pr.category_idORDER BY category_name, product_name ASCOutput:CATEGORY_NAMEPRODUCT_NAMELIST_PRICEBasses Fender Precision 799.99Basses Hofner Icon 499.99Drums CATEGORY_NAMEPRODUCT_NAMELIST_PRICELudwig 5-piece Drum Set with Cymbals 699.99Drums Tama 5-Piece Drum Set with Cymbals 799.99Guitars Fender Stratocaster

699CATEGORY_NAMEPRODUCT_NAMELIST_PRICEGuitars Gibson Les Paul 1199Guitars Gibson SG 2517Guitars CATEGORY_NAMEPRODUCT_NAMELIST_PRICERodriguez Caballero 11 415Guitars Washburn D10S 299Guitars Yamaha FG700S 489.9910 rows selected

Explanation:

answer; fosslls and artifacts;