NO CONCAT answers please Thank you . if possible just the basics JOINS " Inner and Outer Joins, left, right, full" and Set Operators "UNION /all , intersect and minus"

SQL

Question 1) Show all of the department managers who work in Seattle. Your report should include their manager ID, full name, department name and the city name.

Question 2) Show all the Department Names, along with their manager's full names, job titles and salaries. Note: Department's without a manager will not be shown.

Question 3) Using a SET operator, Display all names that are used both as a last name and a first name. Example: Taylor Grant, Winston Taylor We want to display the name Taylor because it is used in both columns.

Question 4) Display country name and city name. Only show countries without a city and cities without a country.

Employees ot OH PK employee id -Attached first_name Jobs last_name OH PK job id Job_History email PK Manages employee id [FK) Hired job_title Detailed phone_number min_salary PK start date hire_date max_salary end_date job_id [FK] department_id [FK] salary job_id [FK] commission_pct manager_id [FK] Departments oh PK department id Ho -Associated department_id [FK] department_name Locations manager_id [FK] Heads PK location id location_id [FK] po-Located street_address Regions postal_code PK region id Ito -Grouped Countries city PK country_id Ho-Resides region_name state_province country_name country_id [FK) region_id [FK]