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: Comparative list of supplier or consumer states andcities with respective number of suppliers and consumers in eachcity (columns are State, City, NumberOfSuppliers,NumberOfConsumers)?
Expert Answer
An answer will be send to you shortly. . . . .