Q1) Consider the employees database , where the primary keys are underlined. Give an expression in SQL for each of the following queries. Employee(ID, name, age, address, salary, departmet,...


Q1) Consider the employees database , where the primary keys are<br>underlined. Give an expression in SQL for each of the following queries.<br>Employee(ID, name, age, address, salary, departmet,<br>position,ministry_name)<br>Ministry(ministry name, address,No_of_ employee, No_of_dept.,<br>category)<br>1- Find all employees who work in ministery of foreign affairs And their<br>age less than the average age all the employees who work in the ministery<br>of education.<br>2- Find the name of employees who work as a manger in ministries that<br>have more than 100 employee and lies in baghdad city.<br>

Extracted text: Q1) Consider the employees database , where the primary keys are underlined. Give an expression in SQL for each of the following queries. Employee(ID, name, age, address, salary, departmet, position,ministry_name) Ministry(ministry name, address,No_of_ employee, No_of_dept., category) 1- Find all employees who work in ministery of foreign affairs And their age less than the average age all the employees who work in the ministery of education. 2- Find the name of employees who work as a manger in ministries that have more than 100 employee and lies in baghdad city.

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here