1. Please create a query output (referred to as a view) showing Sales Invoice ID and number of items to be shipped with each sale (number of items in the box).

Question: How would I create this query in Access/what would my Select, From, and Where statements be for this query?

Orderlines Order ID Product ID Order_price_per Quantity_ordered Suppliers Supplier_ID Supplier_Name Contact_Name Contact_Title Supplier Address Supplier_City Supplier_Region Supplier Zip Supplier_Country Supplier_Phone Supplier_Fax Orders Order ID Customer ID Employee ID Order Date Required Date Customers Customer_id Cust_First Name Cust_last_Name Cust_Birthdate Cust_Income_Bracket Cust Address Cust_City Cust_Region Cust.zip cust_country Cust phone Cust_fax Products Y Product ID Product Name Supplier_ID Category ID Unit List Price Units In Stock Units On Order Reorder Level Discontinued Code Salelines Sales Invoice ID Product ID Sales_price_per Quantity_sold Item Discount Sales Sales Invoice ID Order ID Customer ID Employee ID Shipped date Shipper id Freight_charges Ship to Name Ship to Address Ship to City Ship to Region Ship to Postal Code Ship to Country Employees Employee_ID emp_Lastname emp_Firstname emp Title emp_Birth_Date emp_Hire_Date emp Address emp City emp Region emp Zip emp Country emp_Phone emp Notes emp ReportsTo Categories Category_ID Category Name Category Description Shippers Shipper ID Shipper Name Shipper Phone 29