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.
Table :- EmpProject
EmpId ProjectId ClientID Project name StartYear EndYear
101 p-1 Cl-1 pharmacy 2010 2010
102 p-2 Cl-2 textile 2010 2012
103 p-1 Cl-3 travels 2013
104 p-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.