Assignment-4O.sql

--create database 
create database a4o;
use a4o;

--import worker.csv into database
select * from worker;

--Q.1 From workers table print first, last names along with their department in descending order of salaries

SELECT FIRST_NAME, LAST_NAME, DEPARTMENT fROM [dbo].[Worker] ORDER BY SALARY DESC;

--Q.2 From workers table print first, last names in descending order of seniority (based on joining date)

Select FIRST_NAME, LAST_NAME FROM WORKER ORDER BY JOINING_DATE ASC;

--Q.3 From the workers table print Unique departments.

Select distinct department from Worker;

--Q.4 From workers table print salaries of HR who are earning greater than 10,000.

select salary from worker where DEPARTMENT='HR' AND SALARY > 10000;

--Q.5 From workers table print first names and last names of employees whose last names starts with A

select FIRST_NAME, LAST_NAME from worker where LAST_NAME LIKE 'A%';

--Q.6 From workers table print last names of employees which has w in them

select LAST_NAME FROM WORKER WHERE LAST_NAME LIKE '%w%';