DATABASE PRACTICAL
ANSWER ALL QUESTIONS BASED ON THE TABLES GIVE.
YOU NEED TO WRITE THE SQL QUERY AND THE EXPECTED OUTPUT. Q1 HAS BEEN DONE FOR YOU.
Copyright By PowCoder代写 加微信 powcoder
Table Name:- Employee
Department
1234567890
1234567890
1234567890
1234567890
1234567890
Table :- EmpDept
Development
Hous Keeping
Table :- EmpSalary
IsPermanent
Table :- Project
Table :- Country
Table :- ClientTable
ClientName
tech altum
Table :- EmpProject
1. Select the detail of the employee whose name start with P.
SELECT * FROM employee where empname like ‘p%’
2. How many permanent candidate take salary more than 5000.
3. Select the detail of employee whose emailId is in gmail.
4. Select the details of the employee who work either for department E-104 or E-102.
5. What is the department name for DeptID E-102?
6. What is total salarythat is paid to permanent employees?
7. List name of all employees whose name ends with a.
8. List the number of department of employees in each project.
9. How many project started in year 2010.
10. How many project started and finished in the same year.
11. select the name of the employee whose name’s 3rd charactor is ‘h’.
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com