Problem Statement

Problem Description Write a SQL query to retrieve the addresses of all departments. You need to combine data from the departments , locations , and countries tables to construct the full address for each department. Schema The database contains the following tables (standard HR Schema): CREATE TABLE regions ( region_id INT PRIMARY KEY, region_name VARCHAR(25) ); CREATE TABLE countries ( country_id CHAR(2) PRIMARY KEY, country_name VARCHAR(40), region_id INT ); CREATE TABLE locations ( location_id INT PRIMARY KEY, street_address VARCHAR(40), postal_code VARCHAR(12), city VARCHAR(30), state_province VARCHAR(12), country_id CHAR(2) ); CREATE TABLE departments ( department_id INT PRIMARY KEY, department_name VARCHAR(30), location_id INT ); CREATE TABLE employees ( employee_id INT PRIMARY KEY, first_name VARCHAR(20), last_name VARCHAR(25), email VARCHAR(25), phone_number VARCHAR(20), hire_date DATE, job_id VARCHAR(10), salary DECIMAL(8,2), commission_pct DECIMAL(2,2), manager_id INT, depart