Creating Queries
Read the assignment carefully please.
Before completing this assignment you will need to have:
- Imported the Custom and Item data
- Created entries in the Orders and Order Items tables
- Verified the tables have proper ID values to ensure they are joined properly
Using the database you created in Week One, create the following queries:
- A query showing all customers. Name the query, ‘All Customers’. Include all customer columns in the query.
- A query showing all customers whose last name is ‘Miller’. Include all customer columns in the query. Name the query, ‘Customers by Name’.
- A query showing all Items with a price less than $5.00. Name the query, ‘Less Expensive Items’. Include all columns in the query.
- A query showing all orders for a particular customer (you may choose the customer and use the name or ID to select the customer).
Address the following:
- Display only the order ID, the order date, and the customer name.
- Name the query, ‘Customer Orders’. Note: You will only return orders for a single customer.
Make a copy of the ‘Customer Orders’ query you created. Name it, ‘Customer Invoice’, and include the items for the order.
Address the following:
- Include the following for the items: Item Name, Quantity, and Price.
- Display the columns: Order ID, Order Date, Ship Date, Item Name, Item Price, Quantity, Customer First and Last Name, Address, City, State, and Zip.
- Add a calculated field called, ‘Total’, for the item total (the number of items (Quantity) multiplied by the ItemPrice). The field in the design view should look like the following: Total: [Quantity]*[ItemPrice]
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
