Description

EmpID (PK) EmpFna me EmpLn ame Department Project Address DOB Gender Salary
1 Sanjay Mehra HR P1 Hyderaba d(HYD) 01/12/19
76 M 50000
2 Ananya Mishra Admin P2 Delhi(DEL ) 02/05/19
68 F 75000
3 Rohan Diwan Account P1 Mumbai( BOM) 01/01/19
80 M 90000
4 Sonia Kulkarn
i HR P3 Hyderaba d(HYD) 02/05/19
92 F 50000
5
.
. Priya
.
. Thakur
.
. Developme nt
.
. P2
.
. Bangalore
.
. 23/02/199
2
.
. F
.
. .100000
.
You can add as many rows you want.To demonstrate the queries.
Perform the following queries:-
1.Display details of employees in the HR department only.
2.List number of female employees.
3. Display all female HR employees.
4.Display all the names whose name starts with vowels
5.List all the males whose name has a vowel as the 2nd character.
6.Name of all departments
7.all the female employees earning less than 75000.
8.count number of employees earning between 50k and 1 lakh.
9.count the number of projects.
10.Department wise count of employees.
Q2.
1. What is the difference between a Unique Key and Primary Key?
2.SQL is a case-sensitive language. (True or False)