2 Question about Database SQL exercise 1. Our company needs a listing of each pr

Question

2 Question about Database SQL exercise

1. Our company needs a listing of each product we sell. Create a query that shows the Category Name, Product Name, Description, and Price for each Product. Sort the result set by the Category Name and then by the Product Name, in ascending order.

2. We need to mail an invoice to each one of our customers. Create a query that contains the First Name, Last Name, and full mailing address information (Street, City, State, Zip Code). Make sure to use billing addresses and not shipping addresses.

Explanation / Answer

1.

SELECT Categories.CategoryName,Products.ProductName,Description,Price FROM Categories INNER JOIN Products ON Categories.CategoryID=Products.CategoryID order by CategoryName,ProductName;

2.

Select CompanyName,ContactName,Address,City,Region,PostalCode from Customers;

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.