Untitled

Write a query to fetch the EmpFname from the EmployeeInfo table in the upper case and use the ALIAS name as EmpName.

Write a query to fetch the number of employees working in the department ‘HR’.

Write a query to get the current date.

EmployeeInfo Table:
EmpID

EmpFname

EmpLname

Department

Project

Address

DOB

Gender

1

Sanjay

Mehra

HR

P1

Hyderabad(HYD)

01/12/1976

M


EmployeePosition Table:
EmpID

EmpPosition

DateOfJoining

Salary

1

Manager

01/05/2024

500000