DBI202_-_PE_-_02_-_SP_2024_-_Block_3_1893.webp

EmpNo
1
EmpName
Salary
Eminem
1000.00
Picture 3.1
Question 4:
Write a query to list all employees that have the same name. The result includes: employee no, employee name, start date, salary
EmployeeNo
3
4
EmployeeName
Nick
Nick
StartDate
Salary
2022-12-12 900.00
2023-12-12 700.00
Picture 4.1
Question 5:
Write a query to count the number of employees of the department
DeptName
IT
Sales
NumOfEmployee
3
1
Picture 5.1
Zoom
+ 100%
Close