Create a copy of Cap1 Hiking Query named Cap1 Hiking and Biking Shoes Query. Red

Question

Create a copy of Cap1 Hiking Query named Cap1 Hiking and Biking Shoes Query. Redesign the query design to answer the question What is the sport, item name, retail price, and supplier ID for the category of shoes where the sport is hiking or biking? Arrange the fields in the order in which they're mentioned in the question. Sort the records first in ascending order by Sport and then in ascending order by Item Name. Do not display the Category field in the query results, but display the Sport field. Run and then close the query. Six records match the criteria.

Explanation / Answer

In order to provide you the exact query, I need to have a look into the database tables and then decide the correct column names.

Since you have not provided the schema details, I will just guess the table names (hence, the query might not run succesfully). If you can replace the column names yourself, then it might run. Otherwise, get back to me with the schema details and i will help you with it.

The query is given below.

SELECT s.SportName, i.ItemName, i.RetailPrice, i.SupplierID FROM Sport s, Item i

WHERE i.Category = 'shoes' AND s.SportName in ('hiking', 'biking')

ORDER BY s.SportName, i.ItemName;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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