Database Query: Employee (ID, First_name, Last_name, Joining_date, Salary) Employee_Info(Emp_ID, Designation) (i) Create both tables. (ii) Show…
Database Query:
Employee (ID, First_name, Last_name, Joining_date, Salary)
Employee_Info(Emp_ID, Designation)(i) Create both tables.
(ii) Show department-wise min, max, average salary of employees.
(iii) Show details of employees joined before February 2023.
From the MRA Senior Computer Operator February 2023 – Written (IBA) exam, question 4 of 11.
More from this paper
- Previous: Write a simple C program in which a function is called by value, and show its output: the previous value of the variable and the…
- Next: Derive given Boolean expression using only NAND gate. F = A'B'C'D' + AB'CD' + AB'C'D' + A'CD + A'B'CD'
- All questions in MRA Senior Computer Operator February 2023 – Written (IBA)