Based on the  Below tables, write sql statement using JOIN to display department name, manager_id , street Address and post_code. Include only location_id that are assigned to a department.

  

Transcribed Image Text:

location_id street_address 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2200 2300 1297 Via Cola di Rie 93091 Calle della Testa 2017 Shinjuku-ku 9450 Kamiya-cho 2014 Jabberwocky Rd 2011 Interiors Blvd 2007 Zagora St 2004 Charade Rd 147 Spadina Ave 6092 Boxwood St 40-5-12 Laogianggen 12-98 Victoria Street 199 Clementi North postal_code 00989 10934 1689 6823 26192 99236 50090 98200 M5V 2L7 YSW 9T2 190518 2901 540199 city Roma Venice Tokyo Hiroshima Southlake South San Fra South Brunsw Seattle Toronto Whitehorse Beijing Sydney Singapore location_id street_address 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2200 2300 1297 Via Cola di Rie 93091 Calle della Testa 2017 Shinjuku-ku 9450 Kamiya-cho 2014 Jabberwocky Rd 2011 Interiors Blvd 2007 Zagora St 2004 Charade Rd 147 Spadina Ave 6092 Boxwood St 40-5-12 Laogianggen 12-98 Victoria Street 199 Clementi North postal_code 00989 10934 1689 6823 26192 99236 50090 98200 M5V 2L7 YSW 9T2 190518 2901 540199 city Roma Venice Tokyo Hiroshima Southlake South San Fra South Brunsw Seattle Toronto Whitehorse Beijing Sydney Singapore

Answer rating: 100% (QA)

You can use the SQL JOIN operation between the departments and locations tables to displa... View the full answer