Chapter_4_Queries_OUT

Q3 what are the names addresses of the q3 customers

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: levisions Answer were sold in October? Q3: What are the names & addresses of the Q3: customers buying televisions in October? Select tables to meet our needs for Q3: What are the names & addresses of the Q3: customers buying televisions in October? Select tables to meet our needs for ‘Date’ ‘Customer#, CName, CStreet, CCity, CState’ ‘Quantity’ ‘Description’ Q3: What are the names & addresses of the Q3: customers buying televisions in October? Need ‘Date’ from Sales table Need ‘Customer#, CName, CStreet, CCity, CState’ from Customer table Need ‘Quantity’ from Sales-Inventory table Need ‘Description’ from Inventory table Apply Date criteria as ‘Between ‘10/1/2005 Apply and 10/31/2005’& Apply Description criteria as ‘Television’ Answer Answer to Q3: What are the names & addresses of the customers buying televisions in October? Q4: Q4: What are the sales invoice numbers, dates & invoice totals for all sales in October, arranged in descending order by amount of the sale? Q4: Q4: What are the sales invoice numbers, dates & invoice totals for all sales in October, arranged in descending order by amount of the sale? Need ‘Date, Sales Invoice#’ from Sales table Need ‘Quantity’ from Sales-Inventory table Need ‘Unit Price’ from Inventory table Q4: Q4: What are the sales invoice numbers, dates & invoice totals for all sales in October, arranged in descending order by amount of the sale? Apply criteria on Date as ‘Between 10/1/2005 and 10/31/2005’ Display only Sales Invoice# Date Invoice Total to be built (see below) Right-click Right-click mouse to select Build from menu Create the Invoice Total column by typing : type “Invoice Total ” Create formula by typing ‘sum( Create Select Sales-Inventory table then ‘Quantity’ Select multiplication symbol * Select Inventory table then ‘Unit Price’ Type ) Right-click Right-click to add the ‘Total’ line Select ‘Expression’ from the menu Select Select ‘Descending’ from the Sort line Answer Answer to Q4: What are the sales invoice numbers, dates & invoice totals for all sales in October, arranged in descending order by amount of the sale? Q5: What are total sales by salesperson? Q5: Q5: What are total sales by salesperson? Q5: Need ‘Salesperson’ from Sales table Need ‘Quantity’ from Sales-Inventory table Need ‘Unit Price’ from Inventory table : Create “Salesperson Total ” by typing Create Right-click mouse to select Build from menu Create formula by typing ‘sum( Create Select Sales-Inventory table then ‘Quantity’ Type multiplication symbol * Select Inventory table then ‘Unit Price’ Type ) Right-click Right-click to add the ‘Total’ line Select ‘Expression’ from the menu Answer to Q5: What are total sales by Answer salesperson?...
View Full Document

Ask a homework question - tutors are online