Question

could you pls help me with this SQL question? thx!
Write a working code in SQL which takes information from table 1 (named as "Table_1") and table 2 (named as "Table_2") to produce table 3 (named as "Table_3"). Table 1 Table 2 DistrictID Regi Partnerid P1001 P1002 Partner Type DistrictID Business SD002 Civic SD003 SD001 SD002 SD003 SD004 SD005 East West North South East P1003 Business SD004 P1004 P1005 Government SD005 Government SD003 SD006 North

Answer 1

Select distinct Region,PartnerType, Count(PartnerType) as Total from Table1 inner join Table2 on Table1.DistrictID = Table2.DistrictID group by Region, PartnerType order by PartnerType;

Do ask if any doubt. Please up-vote.