w3resource

SQL exercises on employee Database: Display the location of CLARE

SQL employee Database: Exercise-71 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

71. From the following table, write a SQL query to find the department location of employee ‘CLARE’. Return department location.

Pictorial Presentation:

SQL exercises on employee Database: Display the location of CLARE

Sample table: employees


Sample table: department


Sample Solution:

SELECT dep_location
FROM department d,
     employees e
WHERE e.emp_name = 'CLARE'
  AND e.dep_id = d.dep_id ;

Sample Output:

 dep_location
--------------
 SYDNEY
(1 row)

Relational Algebra Expression:

Relational Algebra Expression: Display the location of CLARE.

Relational Algebra Tree:

Relational Algebra Tree: Display the location of CLARE.

Practice Online


Sample Database: employee

employee database structure

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find those employees who are either 'CLERK' or 'ANALYST’. Sort the result set in descending order on job_name. Return complete information about the employees.
Next: From the following table, write a SQL query to find those employees who joined on 1-MAY-91, or 3-DEC-91, or 19-JAN-90. Sort the result-set in ascending order by hire date. Return complete information about the employees.

What is the difficulty level of this exercise?