Scribd
Upload
4 views5 pages

SQL Queries for Employee Data Analysis

The document contains 30 questions related to querying and manipulating data from employee and salary tables using SQL. The questions cover a range of SQL functions and clauses including aggregation, filtering, joins, string operations, and date calculations. The goal of the questions is to select, filter, and transform data from the tables in various ways to test SQL skills.

Uploaded by

Lyeba Ajmal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views5 pages

SQL Queries for Employee Data Analysis

The document contains 30 questions related to querying and manipulating data from employee and salary tables using SQL. The questions cover a range of SQL functions and clauses including aggregation, filtering, joins, string operations, and date calculations. The goal of the questions is to select, filter, and transform data from the tables in various ways to test SQL skills.

Uploaded by

Lyeba Ajmal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

ASSIGNMENT 02

LYEBA AJMAL
BCSF19M519
QUESTION 1)
SELECT DISTINCT(Project)

FROM EmployeeSalary;

QUESTION 2)
SELECT Max(Salary), Min(Salary), AVG(Salary)

FROM EmployeeSalary;

QUESTION 3)
SELECT Emp_ID, Salary

FROM EmployeeSalary

WHERE Salary BETWEEN 9000 AND 15000;

QUESTION 4)
SELECT EmpId, City, ManagerId

FROM EmployeeDetails

WHERE City='Toronto'

AND ManagerId='321';

Question 5)

SELECT *
FROM EMPLOYEEDETAILS E, EMPLOYEESALARY S

WHERE E.EMP_ID <> S.EMP_ID

Question 6)

SELECT *

FROM EMPLOYEEDETAILS E

LEFT JOIN EMPLOYEESALARY S

ON E.EMP_ID = S.EMP_ID

WHERE S.EMP_ID IS NULL

Question 7)

SELECT MOD(SALARY,500) AS “TOTAL SALARY”

FROM EMPLOYEESALARY

WHERE PROJECT = ‘MANAGER’

ORDER BY “TOTAL SALARY”

Question 8)

SELECT EMP_ID , FULL_NAME , MANAGER_ID , DATE_JOINING , ADD_MONTHS(DATE_JOINING,7)


AS “NEW DATE”

FROM EMPLOYEEDETAILS

Question 9)

SELECT EMP_ID, SALARY+(0.25*SALARY) AS “INCREMENT”

FROM EMPLOYEESALARY

WHERE (SALARY+(0.25*SALARY) > 3000

Question 10)
SELECT EMP_ID , PROJECT

FROM EMPLOYEESALARY

WHERE PROJECT <> ‘P1’

Question 11)

SELECT FULL_NAME

FROM EMPLOYEEDETAILS

WHERE FULL_NAME LIKE ‘__HN%’

Question 12)

Question 13)

SELECT FULL_NAME , REPLACE(FULL_NAME,’ ’,’-’)

FROM EMPLOYEEDETAILS

Question 14)

SELECT CITY , INSTR(CITY,’M’) AS “POSITION”

FROM EMPLOYEEDETAILS

Question 15)

SELECT EMP_ID || ‘ ’ || MANAGER_ID

FROM EMPLOYEEDETAILS

Question 16)

SELECT SUBSTR(FULL_NAME,1,INSTR(FULL_NAME,’ ’)-1)

FROM EMPLOYEEDETAILS

Question 17)

SELECT FULL_NAME , LENGTH(FULL_NAME) – LENGTH(REPLACE(FULL_NAME,’N’,’’)) as “Number


of N”
FROM EMPLOYEEDETAILS

Question 18)

SELECT EMP_ID

FROM EMPLOYEESALARY

WHERE PROJECT IS NULL

Question 19)

SELECT RTRIM(FIRST_NAME)

FROM WORKER

Question 20)

SELECT LTRIM(DEPARTMENT)

FROM WORKER

Question 21)

SELECT REPLACE(FIRST_NAME,’a’,’A’)

FROM WOKER

Question 22)

SELECT FIRST_NAME || ‘ ’ || LAST_NAME AS “COMPLETE NAME”

FROM WORKER

Question 23)

SELECT W.*, T.WORKER_TITLE

FROM WORKER W , TITLE T

WHERE W.WORKER_ID = T.WORKER_ID

AND T.WORKER_TITLE = ‘MANAGER’


Question 24)

Question 25)

Question 26)

SELECT TO_CHAR(NEXT_DAY(ADD_MONTHS(HIREDATE, 6), 'FRIDAY'),'Day,Monthddth, YYYY')

FROM EMP

ORDER BY HIREDATE;

Question 27)

SELECT SUBSTR(ENAME,1,3) , SUBSTR(PNAME,-3,3)

FROM PROJ

WHERE LENGTH(PNAME) > 5

Question 28)

Question 29)

SELECT ‘$’ || ROUND((SAL/100)) AS “DOLLAR SALARY”

FROM EMP

WHERE INITCAP(PNAME) = PNAME

AND MOD(SAL,20) = 0

Question 30)

You might also like