w3resource
SQL exercises

SQL exercises on employee Database: Produce the output of employees

SQL employee Database: Exercise-6 with Solution

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

6. Write a query in SQL to produce the output of employees as follows:
Employee
JONAS(manager).

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: Produce the output of employees

Sample Solution:

SELECT emp_name || '('|| lower(job_name)||')' AS "Employee"
FROM employees;

Sample Output:

      Employee
--------------------
 KAYLING(president)
 BLAZE(manager)
 CLARE(manager)
 JONAS(manager)
 SCARLET(analyst)
 FRANK(analyst)
 SANDRINE(clerk)
 ADELYN(salesman)
 WADE(salesman)
 MADDEN(salesman)
 TUCKER(salesman)
 ADNRES(clerk)
 JULIUS(clerk)
 MARKER(clerk)
(14 rows)

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 produce the output of employees name and job name as a format of "Employee & Job".
Next: Write a query in SQL to list the employees with Hire date in the format like February 22, 1991.

What is the difficulty level of this exercise?