1. Add the Suppliers table to the Data Source.
2. Join in the Purchase_Orders table as an Inner join.
3. Edit the relationship between the Suppliers table and Purchase-Orders table to be a Left join.

Answer the following questions:

1. How many rows are included in the data set when using Inner join? Left join?
2. How many Suppliers exist in the Suppliers table that have not been on any orders in the Purchase_Orders table?
3. Add Supplier Company Name to your sheet so you can see the names associated with the supplier IDs. Which of the following is one of the companies that has not yet had an order placed with them?
4. How many orders have been placed with Hops Direct?
5. How many orders have been placed with suppliers in Arkansas (AR)?

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline 1 Supplier_ID & & Supplier_Company_name & Supplier_Address & Supplier_City & \begin{tabular}{l|l} & Supplier_St \\ \end{tabular} & Supplier_Zip & Supplier_Phone & Notes & & \\ \hline 2 & 1 & Northern Brewery Homebre & w S 6021 Lyndale Ave S & Minneapolis & MN & 55419 & 6128434444 & \multicolumn{2}{|c|}{ Bulk Malt Supplier } & \\ \hline 3 & 2 & Hops Direct, LLC & 686 Green Valley Road & Mabton & WA & 98935 & 5098373616 & Bulk Hops & os Supplier & \\ \hline 4 & 3 & The Home Brewery & 455 E. Township St. & Fayetteville & AR & 72703 & 4795871440 & \multicolumn{3}{|c|}{ Small batch and Speciality Ingredient Supplier } \\ \hline 5 & 4 & The Payroll Company & 408 N. Walton Blvd & Bentonville & AR & 72712 & 1-866-899-8439 & Payroll & & \\ \hline 6 & 5 & City of Fayetteville - Water & 113 West Mountain Stre & Fayetteville & AR & 72701 & 4795211258 & Water & & \\ \hline 7 & 6 & Southwestern Gas & P.O. Box 98890 & Las Vegas & NV & & 8778606020 & \multicolumn{2}{|c|}{ Electric and Gas } & \\ \hline 8 & 7 & Bob's Repair & 3541 Horse Meadow Dri & i Fayetteville & AR & 72703 & 4793452345 & Repairs & & \\ \hline 9 & 8 & Farmer's Insurance & 1943 College Avenue & Fayetteville & AR & 72701 & 479-236-0013 & Insurance & & \\ \hline 10 & 9 & Lindsey Management Co. & 1200 East Joyce Blvd. & Fayetteville & AR & 72703 & 4795216686 & Rent & & \\ \hline \end{tabular}