DBM 261 Week 3 Query Building Exercise

Description

Build queries through SQL along with the query-building tool with sales databases built in Week Two for Riordan Manufacturing.

Create a separate table for query information. Include the query name and query description.

Enter data into the fields, naming and describing as many queries as you can, and then write two thirds of the queries using the query-building tool.

Write the remaining queries in SQL.

Create a new query without the tools and enter the SQL into its view.

Test your queries to verify that they return the data you described.