Write a working code in SQL which takes information from table 1 (named as Table_1) and...

Transcribed Image Text:

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 DistrictID S0001 SD002 SD003 SD004 SD005 SD006 Region East West North South East North Table 3 Region East West North South Table 2 PartnerID P1001 P1002 P1003 P1004 P1005 Partner Туре Business Civic Partner Type DistrictID Business Civic Business Government Business Civic Government SD005 Government SD003 Government Business Civic Government Business Civic Total 15 7 6 18 9 14 2 7 SD002 SD003 SD004 13 4 6 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 DistrictID S0001 SD002 SD003 SD004 SD005 SD006 Region East West North South East North Table 3 Region East West North South Table 2 PartnerID P1001 P1002 P1003 P1004 P1005 Partner Туре Business Civic Partner Type DistrictID Business Civic Business Government Business Civic Government SD005 Government SD003 Government Business Civic Government Business Civic Total 15 7 6 18 9 14 2 7 SD002 SD003 SD004 13 4 6

Answer rating: 100% (QA)

Answer Assuming that the PartnerType column is present in Table2 and Region col... View the full answer