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 live in baghdad and work in ministery of foreign affairs And older than all the employees who work in the consuls department. 2- Find the name of employees who work as a counselor in ministries that have more than 5 departments . 3- Insert a new employee (o the database. Q1) Consider the employees database, where the primary keys areunderlined. 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 live in baghdad and work in ministery offoreign affairs And older than all the employees who work in the consulsdepartment.2- Find the name of employees who work as a counselor in ministriesthat have more than 5 departments.3- Insert a new employee to the database.

1- select * from Employee where address='baghdad' and ministry_name='foriegn affairs' and…

Answered: Q1) Consider the employees database ,…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

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 live in baghdad and work in ministery of foreign affairs And older than all the employees who work in the consuls department. 2- Find the name of employees who work as a counselor in ministries that have more than 5 departments . 3- Insert a new employee (o the database.