List the names of customers who do not have any order. Result has schema: (first name, last name) q2: List the names of employees who are customers but do not have any orders. Result has schema: (first name, last name) q3: List employees who map to the same customer id. (That is, employees who have different emp id but the same customer id.) Result has schema: (first name, last name)

 

Transcribed Image Text:

Addresses address_id customer_id linel line2 1 1 2 1 3 2 100 East Ridgewood Ave. 21 Rosewood Rd. 16285 Wendell St. city Paramus state Woodcliff Lake Omaha 4 3 19270 NW Cornell Rd. Beaverton 5 4 186 Vermont St. Apt. 2 San Francisco 6 4 1374 46th Ave. San Francisco 7 5 6982 Palm Ave. Fresno 8 6 23 Mountain View St. Denver 9 7 7361 N. 41st St. Apt. B New York 10 7 3829 Broadway Ave. Suite 2 New York 11 8 12 8 2381 Buena Vista St. 291 W. Hollywood Blvd. Los Angeles Los Angeles 2 J 8 J J NJ zip_code 7652 phone 201-653-4472 disabled 0 NJ 7677 201-653-4472 0 NE 68135 402-896-2576 0 OR 97006 503-654-1291 CA 94110 415-292-6651 CA 94129 415-292-6651 CA 93711 559-431-2398 CO 80208 303-912-3852 NY 10012 212-335-2093 NY 10012 212-239-1208 O O O O O O O c 0 0 0 0 0 0 CA 90023 CA 90024 213-772-5033 213-391-2938 0 0 Categories category_id category_name 1 customers customer_id 2 3 4 Guitars Basses 1 2 Drums 3 Keyboards 4 5 6 7 8 email_address password allan@yahoo.com 650215acec barryz@gmail.com 3f563468d42a christine@solar.com ed19f5c083 david@hotmail.com b444ac06613fc erinv@gmail.com 1d7b0df729d299b frank@sbcglobal.net 3ebfa301dc59 gary@sun.com 1ff2b3704aedeb heather@mac.com 911ddc3b8f9a13 first_name last_name Allan Sherwood Barry Zimmer Christine Brown David Goldstein. Erin Valentino Frank Lee Gary Heather Wilson Hernandez Esway Employee employee_id customer id email address 1 1 allan@sun.com first_name Allan last_name Sherwood 2 2 barryz@sun.com Barry Zimmer 3 None chris@sun.com Chris Bani 4 2 julyz@sun.com July Zimmer 5 None nina@sun.com Nina 6 7 gary@sun.com Gary Singh Hernandez Order Items item_id order_id product_id 1 1 2 2 3 4 5 6 7 8 9 7 10 7 11 8 12 9 43625SATSUL 2334567 1 6 item_price 1199 489.99 discount_amount 359.7 quantity 1 186.2 1 2517 1308.84 1 415 161.85 1 1199 359.7 2 299 0 1 299 0 1 1 699 209.7 1 7 799.99 240 1 9 699.99 210 1 10 799.99 120 1 1 699 209.7 1 Orders order_id address_id customer_id order_date ship_amount ship_date card_type 1 1 1 2018-03-28 09:40:28 5 2 2 1 2018-03-28 11:23:20 5 3 1 1 2018-03-29 09:44:58 10 4 3. 2 2018-03-30 15:22:31 5 5 4 3 2018-03-31 05:43:11 5 2018-03-30 15:32:51 2018-03-29 12:52:14 2018-03-31 9:11:41 2018-04-03 16:32:21 2018-04-02 14:21:12 Visa Visa Visa American Express 6 5 4 2018-03-31 18:37:22 5 None Visa Discover 7 6 4 2018-04-01 23:11:12 15 2018-04-03 10:21:35 8 7 5 2018-04-02 11:26:38 5 9 4 3 2018-04-03 12:22:31 5 None None MasterCard Visa Visa card_number card_expires 4.11111E+15 04/2020 4.01289E+15 08/2019 4.11111E+15 04/2017 3.78282E+14 04/2016 4.11111E+15 04/2019 6.01111E+15 04/2019 5.55556E+15 04/2019 4.01289E+15 04/2019 4.11111E+15 04/2019 Products product_id category_id product_code product_name list_price discount_percent date_added 1 1 10 1 1 2 2 3 3 1234567829 1 1 1 strat les_paul sg fg700s Fender Stratocaster 699 30 2017-10-30 09:32:40 Gibson Les Paul 1199 30 2017-12-05 16:33:13 Gibson SG 2517 52 2018-02-04 11:04:31 Yamaha FG700S 489.99 38 2018-06-01 11:12:59 washburn Washburn D10S 299 0 2018-07-30 13:58:35 rodriguez Rodriguez Caballero 11 415 39 2018-07-30 14:12:41 precision Fender Precision 799.99 30 2018-06-01 11:29:35 hofner Hofner Icon 499.99 25 2018-07-30 14:18:33 ludwig Ludwig 5-piece Drum Set 699.99 30 2018-07-30 12:46:40 tama Tama 5-Piece Drum Set 799.99 15 2018-07-30 13:14:15 Addresses address_id customer_id linel line2 1 1 2 1 3 2 100 East Ridgewood Ave. 21 Rosewood Rd. 16285 Wendell St. city Paramus state Woodcliff Lake Omaha 4 3 19270 NW Cornell Rd. Beaverton 5 4 186 Vermont St. Apt. 2 San Francisco 6 4 1374 46th Ave. San Francisco 7 5 6982 Palm Ave. Fresno 8 6 23 Mountain View St. Denver 9 7 7361 N. 41st St. Apt. B New York 10 7 3829 Broadway Ave. Suite 2 New York 11 8 12 8 2381 Buena Vista St. 291 W. Hollywood Blvd. Los Angeles Los Angeles 2 J 8 J J NJ zip_code 7652 phone 201-653-4472 disabled 0 NJ 7677 201-653-4472 0 NE 68135 402-896-2576 0 OR 97006 503-654-1291 CA 94110 415-292-6651 CA 94129 415-292-6651 CA 93711 559-431-2398 CO 80208 303-912-3852 NY 10012 212-335-2093 NY 10012 212-239-1208 O O O O O O O c 0 0 0 0 0 0 CA 90023 CA 90024 213-772-5033 213-391-2938 0 0 Categories category_id category_name 1 customers customer_id 2 3 4 Guitars Basses 1 2 Drums 3 Keyboards 4 5 6 7 8 email_address password allan@yahoo.com 650215acec barryz@gmail.com 3f563468d42a christine@solar.com ed19f5c083 david@hotmail.com b444ac06613fc erinv@gmail.com 1d7b0df729d299b frank@sbcglobal.net 3ebfa301dc59 gary@sun.com 1ff2b3704aedeb heather@mac.com 911ddc3b8f9a13 first_name last_name Allan Sherwood Barry Zimmer Christine Brown David Goldstein. Erin Valentino Frank Lee Gary Heather Wilson Hernandez Esway Employee employee_id customer id email address 1 1 allan@sun.com first_name Allan last_name Sherwood 2 2 barryz@sun.com Barry Zimmer 3 None chris@sun.com Chris Bani 4 2 julyz@sun.com July Zimmer 5 None nina@sun.com Nina 6 7 gary@sun.com Gary Singh Hernandez Order Items item_id order_id product_id 1 1 2 2 3 4 5 6 7 8 9 7 10 7 11 8 12 9 43625SATSUL 2334567 1 6 item_price 1199 489.99 discount_amount 359.7 quantity 1 186.2 1 2517 1308.84 1 415 161.85 1 1199 359.7 2 299 0 1 299 0 1 1 699 209.7 1 7 799.99 240 1 9 699.99 210 1 10 799.99 120 1 1 699 209.7 1 Orders order_id address_id customer_id order_date ship_amount ship_date card_type 1 1 1 2018-03-28 09:40:28 5 2 2 1 2018-03-28 11:23:20 5 3 1 1 2018-03-29 09:44:58 10 4 3. 2 2018-03-30 15:22:31 5 5 4 3 2018-03-31 05:43:11 5 2018-03-30 15:32:51 2018-03-29 12:52:14 2018-03-31 9:11:41 2018-04-03 16:32:21 2018-04-02 14:21:12 Visa Visa Visa American Express 6 5 4 2018-03-31 18:37:22 5 None Visa Discover 7 6 4 2018-04-01 23:11:12 15 2018-04-03 10:21:35 8 7 5 2018-04-02 11:26:38 5 9 4 3 2018-04-03 12:22:31 5 None None MasterCard Visa Visa card_number card_expires 4.11111E+15 04/2020 4.01289E+15 08/2019 4.11111E+15 04/2017 3.78282E+14 04/2016 4.11111E+15 04/2019 6.01111E+15 04/2019 5.55556E+15 04/2019 4.01289E+15 04/2019 4.11111E+15 04/2019 Products product_id category_id product_code product_name list_price discount_percent date_added 1 1 10 1 1 2 2 3 3 1234567829 1 1 1 strat les_paul sg fg700s Fender Stratocaster 699 30 2017-10-30 09:32:40 Gibson Les Paul 1199 30 2017-12-05 16:33:13 Gibson SG 2517 52 2018-02-04 11:04:31 Yamaha FG700S 489.99 38 2018-06-01 11:12:59 washburn Washburn D10S 299 0 2018-07-30 13:58:35 rodriguez Rodriguez Caballero 11 415 39 2018-07-30 14:12:41 precision Fender Precision 799.99 30 2018-06-01 11:29:35 hofner Hofner Icon 499.99 25 2018-07-30 14:18:33 ludwig Ludwig 5-piece Drum Set 699.99 30 2018-07-30 12:46:40 tama Tama 5-Piece Drum Set 799.99 15 2018-07-30 13:14:15