CREATE TABLE countries (country_name VARCHAR2, country_id VARCHAR2)
CREATE TABLE locations (location_id VARCHAR2, country_id VARCHAR2)
CREATE TABLE departments (department_id VARCHAR2, location_id VARCHAR2)
CREATE TABLE employees (first_name VARCHAR2, last_name VARCHAR2, employee_id VARCHAR2, department_id VARCHAR2)

display the full name (first and last name ) of employee with ID and name of the country presently where (s)he is working.
SELECT T1.first_name, T1.last_name, T1.employee_id, T4.country_name FROM employees AS T1 JOIN departments AS T2 ON T1.department_id = T2.department_id JOIN locations AS T3 ON T2.location_id = T3.location_id JOIN countries AS T4 ON T3.country_id = T4.country_id
SELECT "T1"."first_name", "T1"."last_name", "T1"."employee_id", "T4"."country_name" FROM "employees" "T1" JOIN "departments" "T2" ON "T1"."department_id" = "T2"."department_id" JOIN "locations" "T3" ON "T2"."location_id" = "T3"."location_id" JOIN "countries" "T4" ON "T3"."country_id" = "T4"."country_id"