Description
Use the AdventureWorks databases to complete the following queries. Copy and paste your query under each question. I do not need to see the results set from running the query.
SALES Database
- Show me all the information on our Stores.
- Show me a list of Sales Territories sorted by Region. Include the Name of the Territory and Region
Production Database
- Show me a list of Products with their number and name in alphabetical order by Name.
- Show me the name of our locations with the Availability.
Person Database
- Show me all the phone number types
- Show me all the persons (Person.person) Last Name and First name sorted by last name ascending and first name descending.
- What titles are associated with our person.person database. Don’t show duplicates.
Human Resources Database
- Show me a list of our Departments sorted by the group name.
- List the times of our shifts
- From our pay history, show me the top 5 rates that we have paid.
When you looked at the results of your query, you should see the values were 125.50, 84.1346, 72.1154, 63.4615, 30.0962.