Question: Use the Employees database to perform the following SQL queries 1.- Count the number of Architects 2.- Select all the Architects with more

Use the Employees database to perform the following SQL queries
1.- Count the number of "Architects"
2.- Select all the Architects with more than 2 departments
3.- Select the titles for the top 5 salaries.
4.- Select the information of all the employees considering their manager information
CREATE TABLE employees ( emp_no INT NOT NULL, birth_date DATE NOT NULL, first_name VARCHAR(14) NOT NULL, last_name VARCHAR (16) NOT NULL, gender ENUM ('M', 'F') NOT NULL, hire_date DATE NOT NULL, PRIMARY KEY (emp_no) ); CREATE TABLE departments dept_no CHAR (4) dept_name VARCHAR(40) PRIMARY KEY (dept_no), UNIQUE KEY (dept_name) NOT NULL, NOT NULL, CREATE TABLE dept_manager ( emp_no INT NOT NULL, dept_no CHAR(4) NOT NULL, from_date DATE NOT NULL, to_date DATE NOT NULL, FOREIGN KEY (emp_no) REFERENCES employees (emp_no) ON DELETE CASCADE, FOREIGN KEY (dept_no) REFERENCES departments (dept_no) ON DELETE CASCADE, PRIMARY KEY (emp_no, dept_no) ); CREATE TABLE dept_emp ( emp_no INT NOT NULL, dept_no CHAR (4) NOT NULL, from_date DATE NOT NULL, to_date DATE NOT NULL, FOREIGN KEY (emp_no) REFERENCES employees (emp_no) ON DELETE CASCADE, FOREIGN KEY (dept_no) REFERENCES departments (dept_no) ON DELETE CASCADE, PRIMARY KEY (emp_no, dept_no) ); CREATE TABLE titles ( emp_no INT NOT NULL, title VARCHAR(50) NOT NULL, from_date DATE NOT NULL, to_date FOREIGN KEY (emp_no) REFERENCES employees (emp_no) ON DELETE CASCADE, PRIMARY KEY (emp_no, title, from_date) DATE, CREATE TABLE salaries ( emp_no INT NOT NULL, salary INT NOT NULL, from_date DATE NOT NULL, to_date DATE NOT NULL, FOREIGN KEY (emp_no) REFERENCES employees (emp_no) ON DELETE CASCADE, PRIMARY KEY (emp_no, from_date)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
