I need help with these 2 questions below. I only need the SQL Syntax, no screenshots needed:

 

 

<<< HERE IS AN IMAGE BELOW OF THE DATABASE SCHEMA WITH EACH OF IT'S TABLES AND COLUMNS, INCLUDING THEIR RELATIONSHIPS WITH EACH OTHER >>>

 

The 2 questions below only needs to be answered with syntax, not other information or screenshots needed. The 2 questions answers need to look like this example below:

 

 

SELECT last_name, order_id, salesman_id, employee_id, first_name
FROM employees
LEFT JOIN orders ON employees.employee_id = orders.employee_id
WHERE salesman_id IS NULL
ORDER BY last_name;

 

 

 

Transcribed Image Text:

CUSTOMERS *CUSTOMER_ID NAME ADDRESS WEBSITE CREDIT_LIMIT ORDERS ORDER_ID CUSTOMER_ID STATUS SALESMAN_ID ORDER DATE ORDER_ITEMS *ORDER_ID *ITEM_ID PRODUCT_ID QUANTITY UNIT_PRICE PRODUCTS *PRODUCT_ID PRODUCT_NAME DESCRIPTION STANDARD_COST LIST_PRICE CATEGORY_ID +++ SCHEMA: cpu_products eH +H CONTACTS *CONTACT_ID FIRST NAME LAST_NAME EMAIL PHONE CUSTOMER_ID EMPLOYEES *EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE HIRE_DATE MANAGER_ID JOB_TITLE INVENTORIES *PRODUCT_ID *WAREHOUSE_ID QUANTITY PRODUCT_CATEGORIES *CATEGORY_ID CATEGORY_NAME REGIONS *REGION_ID REGION_NAME COUNTRIES *COUNTRY_ID COUNTRY_NAME REGION_ID LOCATIONS *LOCATION_ID ADDRESS POSTAL CODE CITY STATE COUNTRY_ID WAREHOUSES *WAREHOUSE_ID WAREHOUSE NAME LOCATION_ID CUSTOMERS *CUSTOMER_ID NAME ADDRESS WEBSITE CREDIT_LIMIT ORDERS ORDER_ID CUSTOMER_ID STATUS SALESMAN_ID ORDER DATE ORDER_ITEMS *ORDER_ID *ITEM_ID PRODUCT_ID QUANTITY UNIT_PRICE PRODUCTS *PRODUCT_ID PRODUCT_NAME DESCRIPTION STANDARD_COST LIST_PRICE CATEGORY_ID +++ SCHEMA: cpu_products eH +H CONTACTS *CONTACT_ID FIRST NAME LAST_NAME EMAIL PHONE CUSTOMER_ID EMPLOYEES *EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE HIRE_DATE MANAGER_ID JOB_TITLE INVENTORIES *PRODUCT_ID *WAREHOUSE_ID QUANTITY PRODUCT_CATEGORIES *CATEGORY_ID CATEGORY_NAME REGIONS *REGION_ID REGION_NAME COUNTRIES *COUNTRY_ID COUNTRY_NAME REGION_ID LOCATIONS *LOCATION_ID ADDRESS POSTAL CODE CITY STATE COUNTRY_ID WAREHOUSES *WAREHOUSE_ID WAREHOUSE NAME LOCATION_ID