Question

"1 USE Createguitarshop DATABASE

Write a SELECT statement that joins the Categories
table to the Products table and returns these columns: CategoryName,
ProductName, ListPrice.
Sort the result set by CategoryName and then by ProductName in ascending order."

Answer 1

To return the CategoryName, ProductName, and ListPrice columns from the Categories and Products tables, use a SQL SELECT statement with a join on the corresponding ID fields, and sort the results by CategoryName and ProductName in ascending order.

Step-by-step explanation:

To join the Categories table to the Products table and return the CategoryName, ProductName, and ListPrice columns, you would need to construct a SELECT statement using SQL. This would involve using the JOIN clause to combine the two tables based on a common column, typically the category ID. Here is an example of how this query could look:

SELECT Categories.CategoryName, Products.ProductName, Products.ListPrice
FROM Categories
JOIN Products ON Categories.CategoryID = Products.CategoryID
ORDER BY Categories.CategoryName ASC, Products.ProductName ASC;

Make sure that the JOIN clause is linking the tables using the foreign key relationship, which is usually stored in the Products table. The ORDER BY clause ensures that the results are sorted first by CategoryName in ascending order and then by ProductName, also in ascending order.