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 Table 3 Total Region East 15 7 6 West 18 Partner Type Business Civic Government Business Civic Government Business Civic Government Business Civic 9 14 North 2 7 13 South