编程代写 DATABASE PRACTICAL

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.

select count(salary) as count from empsalary where ispermanent=’yes’ and salary>5000

3.   Select the detail of employee whose emailId is in gmail.

select * from employee where emaildid like

4.   Select the details of the employee who work either for department E-104 or E-102.

select * from employee where department=’E-102′ or department=’E-104′

select * from employee where department in (‘E-102′,’E-104′)

5.   What is the department name for DeptID E-102?

select deptname from empdept where deptid =’E-102′

6.  What is total salarythat is paid to permanent employees?

select sum(salary) as salary from empsalary where ispermanent=’yes’

7.  List name of all employees whose name ends with a.

select * from employee where empname like ‘%a’

8.  List the number of department of employees in each project.
select count(empid) as employee, projectid from empproject group by projectid

9.  How many project started in year 2010.

select count(projectid) as project from empproject where startyear=2010

10.  How many project started and finished in the same year.

select count(projectid) as project from empproject where startyear=endyear

11.  select the name of the employee whose name’s 3rd charactor is ‘h’.

select * from employee where empname like ‘__h%’

程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com