Table :- EmpProject EmpId Projectld ClientID Project name StartYear EndYear 101 p-1 Cl-1 pharmacy 2010 2010 102 р-2 Cl-2 textile 2010 2012 103 р-1 Cl-3 travels 2013 104 р-4 Cl-1 xerox 2014 2015 105...

Extracted text: Table :- EmpProject EmpId Projectld ClientID Project name StartYear EndYear 101 p-1 Cl-1 pharmacy 2010 2010 102 р-2 Cl-2 textile 2010 2012 103 р-1 Cl-3 travels 2013 104 р-4 Cl-1 xerox 2014 2015 105 p-4 Cl-5 cosmetics 2015 6. List the number of department of employees in each project. 7. How many project started in year 2010. 8. How many project started and finished in the same year. 9. select the name of the employee whose name's 3rd character is 'h'. 10. List all the values of project table in ascending order of project name.


Extracted text: Q1 : Table Name:- Employee Empid EmpName Department ContactNo EmailId EmpHeadId Salary 101 Ayesha E-101 1234567890 [email protected] 105 4000 102 Priya E-104 1234567890 [email protected] 103 6000 103 Neha E-101 1234567890 [email protected] 101 7000 104 Rahul E-102 1234567890 [email protected] 105 4000 105 Abhishek E-101 1234567890 [email protected] 102 5000 1. Select the detail of the employee whose name start with A. 2. Select the details of the employee who work either for department E-104 or E-102. 3. What is the department name for DeptID E-102? 4. What is total salary that is paid to all employees? 5. Select the detail of employee name and department who is getting salary above 5000.