Question

Ashutosh, who is a manager, has created a database to manage employee records. The database includes a table named EMPLOYEE whose attribute names are mentioned below:

EID: Stores the unique ID for each employee.

EMP_NAME: Stores the name of the employee.

DEPT: Stores the department of the employee.

SALARY: Stores the salary of the employee.

JOIN_DATE: Stores the employee’s joining date.

Table: EMPLOYEE

EID	EMP_NAME	DEPT	SALARY	JOIN_DATE
E01	ARJUN SINGH	SALES	75000	2019-11-01
E02	PRIYA JAIN	ENGINEERING	85000	2020-05-20
E03	RAVI SHARMA	MARKETING	60000	2018-08-14
E04	AYESHA	NULL	50000	2021-01-10
E05	RAHUL VERMA	FINANCE	40000	2017-06-25

Write the output of the following SQL Queries:

1. Select SUBSTRING(EMP_NAME, 1, 5) from EMPLOYEE where DEPT = 'ENGINEERING';
2. Select EMP_NAME from EMPLOYEE where month (JOIN_DATE) = 8;
3. Select EMP_NAME from EMPLOYEE where SALARY > 60000;
4. Select count (DEPT) from EMPLOYEE;

Answer 1

1. PRIYA
2. RAVI SHARMA
3. ARJUN SINGH &  PRIYA JAIN
4. 4