using these tables solve the question below focus and read it carefully and try to answer it well :

the question is :

include all tables created in sql and create 20 different sql queries .

-------------------------------------------------------------------------------------------------------------------------

these some instructions for the question :

Creation of Table

Include all tables created in SQL

SQL Queries

Create at least 20 different queries (The queries you may develop, should show the following: A natural language description of the query, The SQL commands, The result generated by SQL. The 20 queries should include: Multiple table join; Use sub-queries; Group data using GROUP BY;

note : use apex oracle : https://apex.oracle.com/ (that is the link of it ) and don't forgot to take a picture for the result of the queries and put the answers as picture and include their text please.

Contains the data of every branch of the company and it's location Department : Contains the data of the departments and in which branch they are Contains the data about the projects and their No and names stanI : Contains the data of every staff in each branch and the projects they work on Contains the data about employment history of each employ in each department and when they started and finished their work Dependent : Contains all the data about each staff dependent like their names, their sex, their DOB and their relationship with the staff