Answer to Question #262767 in Databases | SQL | Oracle | MS Access for SUNNY

Question

create a table and paste the screenshots of the execution done of the given questions:

Write q query to find all the employees whose salary is between 50000 to 100000.

Write a query to find the names of employees that begin with S.

Write a query to retrieve the EmpFname and EmpLname in a single column as FullName. The first name and the last name must be separated with space.

Write a query to fetch all employees who also hold the managerial position using inner join.

Write a query to fetch the department-wise count of employees sorted by departments count in ascending order.

Answer 1

SELECT * FROM EmployeePosition WHERE Salary BETWEEN '50000' AND '100000';

Select * from Worker where EmpFname like 'S%';

SELECT CONCAT(EmpFname , ' ', EmpLname ) As FullName FROM worker;

SELECT DISTINCT W.FIRST_NAME, T.WORKER_TITLE
FROM Worker W
INNER JOIN Title T
ON W.WORKER_ID = T.WORKER_REF_ID
AND T.WORKER_TITLE in ('Manager');

Select * from Worker order by DEPARTMENT ASC;