Untitled

SELECT d.department name, 1.street_address, 1.postal_code c.country_name,r.region name FROM departments d JOIN locations d.location_id = l.location_id JOIN countries c ON l.country_id= c.country_id JOIN regions r ON c.region_id=r.region_id;