- Please Answer All Question Based On Below Tables Make Sure To Use Table Aliases Customer C Customer Id Pk C001 C00 1 (126.16 KiB) Viewed 28 times
Please answer all question based on below tables. Make sure to use table aliases: Customer (C) customer_id (PK) C001 C002 C003 C004 C005 first_name last_name John Kelly Amelia Cruze Sohpia Tom Mia Henry Smith Stark job_title DBA DBA Cashier QA Cashier Order (0) order_id (PK) 1 2 3 4 5 customer_id (FK) C001 C002 C002 C005 C005 order_date shipping_company 9/27/2019 9/30/2019 8/15/2019 8/20/2019 9/15/2019 1. Select full name (i.e. first_name and last_name) and job_title whose customers records exists in customers table but NOT in orders table using sub-query. 2. Select first_name, last_name, shipping_company and order_date for all records from Customers table but ONLY matching records from Orders table for order_date after August 31st 2019. FedEx UPS UPS FedEx UPS