Given the database description below: Tb_Supplier(Supp_ID, Name,City, State) Tb_Consumer(Con_ID, Name, City, State)Tb_Product(Prod_ID, Name, Product_Category, Product_Line,Product_Packaging) Tb_Offers(Supp_ID, Prod_ID, Quantity, Price)Tb_Requests(Con_ID, Prod_ID, Quantity, Price)Tb_Transactions(Tran_ID, Supp_ID, Con_ID, Prod_ID, Quantity, Price)Tb_Date(DateKey, DateYear, DateMonth, DateMonthName, DateWeek,DateDayOfMonth, DateDayOfWeek, FiscalWeek, IsWeekEnd, IsHoliday,HolidayName) Tb_Time(TimeKey, TheHour, IsLunchHour, IsBusinessHour,ShiftNumber)
SQL Query: For each product list the quantity sold by suppliersin Madison to consumers in Chicago versus the quantity sold bysuppliers in Chicago to consumers in Madison (result columns:product name, quantity Madison_Chicago, quantityChicago_Madison)?
Expert Answer
An answer will be send to you shortly. . . . .