SQL exercises

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. Write a query in SQL to 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:

(1 row)

Practice Online

Sample Database: employee

employee database structure

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

Previous: Write a query in SQL to list the employees in descending order who are either 'CLERK' or 'ANALYST'.
Next: Write a query in SQL to list the employees in ascending order of seniority who joined on 1-MAY-91,or 3-DEC-91, or 19-JAN-90.

What is the difficulty level of this exercise?