id EmpName Department ContactNo EmailId EmpHeadId Salary 101 Ayesha E-101 1234567890 isha@gmail.com 105 4000 102 Priya E-104 1234567890 priya@yahoo.com 103 6000 103 Neha E-101 1234567890 neha@gmail.com 101 7000 104 Rahul E-102 1234567890 rahul@yahoo.com 105 4000 105 Abhishek E-101 1234567890 abhishek@gmail.com 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.
Q1 : Table Name:- Employee
Empid EmpName Department ContactNo EmailId EmpHeadId Salary
101 Ayesha E-101 1234567890 isha@gmail.com 105 4000
102 Priya E-104 1234567890 priya@yahoo.com 103 6000
103 Neha E-101 1234567890 neha@gmail.com 101 7000
104 Rahul E-102 1234567890 rahul@yahoo.com 105 4000
105 Abhishek E-101 1234567890 abhishek@gmail.com 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.
Step by step
Solved in 3 steps with 14 images