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_NAME---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------PRODUCT_NAME---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------LIST_PRICE----------Basses Fender Precision 799.99Basses Hofner Icon 499.99Drums CATEGORY_NAME---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------PRODUCT_NAME---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------LIST_PRICE----------Ludwig 5-piece Drum Set with Cymbals 699.99Drums Tama 5-Piece Drum Set with Cymbals 799.99Guitars Fender Stratocaster

699CATEGORY_NAME---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------PRODUCT_NAME---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------LIST_PRICE----------Guitars Gibson Les Paul 1199Guitars Gibson SG 2517Guitars CATEGORY_NAME---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------PRODUCT_NAME---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------LIST_PRICE----------Rodriguez Caballero 11 415Guitars Washburn D10S 299Guitars Yamaha FG700S 489.9910 rows selected ______________________________________________________

Explanation: