customer number Filter customer name contact last name Filter contact first_name Filter phone Filter address linet address line 2 Filter 103 Filter Atelier graphique Schmitt Carine 40.32.2555 112 54, rue Royale Signal Gift Stores King Jean 7025551838 8489 Strong St. 114 Australian Collectors, Co. Ferguson Peter 03 9520 4555 636 St Kilda Road 119 La Rochelle Gifts Labrune Janine 40.67.8555 67, rue des Cinquante Otages 121 Baane Mini Imports NE Bergulfsen Jonas 07-98 9555 Erling Skakkes gate 78 124 Mini Gifts Distributors Ltd. NU Nelson Susan 4155551450 5677 Strong St. 125 Piestrzeniewicz Havel & Zbyszek Co Blauer See Auto, Co. Zbyszek (26) 642-7555 ul. Filtrowa 68 128 Keitel Roland +49 69 66 90 2555 Lyonerstr. 34 129 Mini Wheels Co. Murphy Julie 6505555787 5557 North Pendale Street 131 Lee Kwai 2125557818 897 Long Airport Avenue 141 Freyre Diego (91) 555 94 44 C/ Moralzarzal, 86 144 Berglund Christina 0921-12 3555 Berguvsvgen 8 145 Petersen Jytte 31 12 3555 Vinbaeltet 34 146 land of Toys Inc Euro+ Shopping Channel Volvo Model Replicas, Co Danish Wholesale Imports Saveley & Henriot, Co. Dragon Souveniers, Ltd. Muscle Machine Inc Diecast Classics Inc. Technics Stores Inc. Saveley Mary 78.32.5555 2, rue du Commerce 148 Natividad Eric +65 221 7555 Bronz Sok Bronz Apt. 3/6 Tesi 151 Young Jeff 2125557413 4092 Furth Circle Suite 400 157 Leong Kelvin 2155551555 7586 Pompton St. 161 Hashimoto Juri 6505556809 9408 Furth Circle 166 Handji Gifts & Co Victorino Wendy +65 224 1555 106 Linden Road Sandowns 2nd Floor 167 Herkku Gifts Oeztan Veysel +47 2267 3215 Brebmen St. 121 PR 14 Sentrum 168 American Souvenirs Inc Franco Keith 2035557845 149 Spinnaker De Suite 101 169 de Castro Porto Imports Co. Daedalus Designs Imports Isabel (1) 356-5555 Estrada da sade n. 58 171 Rance Martine 20.16.1555 184, chausse de Tournai Using the supplied ERD for the database assignment, correctly identify the relationships between the tables presented below: A product belongs to product line(s) Choose... A customer may place order(s) Choose... An order contains order detail(s) Choose... A payment is made by customer(s) Choose... An employee works out of office(s) Choose... Complete the query below so that it returns the order numbers for all orders purchased by customer number 129 (there should matched records) SELECT FROM orders - 129; Complete the query below so that it returns the average MSRP for the company's plane products (should round to 89.52). SELECT (msrp) FROM products WHERE Complete the query below so that it returns the customer number and payment date for payments made for $100,000 and over in 20 (which means that orders that equal $100,000 should be included in the range), Should return 2 records. SELECT customer_number, payment_date, amount FROM payments WHERE amount 100000 payment_date 2019-12-31'; customer number Filter customer name contact last name Filter contact first_name Filter phone Filter address linet address line 2 Filter 103 Filter Atelier graphique Schmitt Carine 40.32.2555 112 54, rue Royale Signal Gift Stores King Jean 7025551838 8489 Strong St. 114 Australian Collectors, Co. Ferguson Peter 03 9520 4555 636 St Kilda Road 119 La Rochelle Gifts Labrune Janine 40.67.8555 67, rue des Cinquante Otages 121 Baane Mini Imports NE Bergulfsen Jonas 07-98 9555 Erling Skakkes gate 78 124 Mini Gifts Distributors Ltd. NU Nelson Susan 4155551450 5677 Strong St. 125 Piestrzeniewicz Havel & Zbyszek Co Blauer See Auto, Co. Zbyszek (26) 642-7555 ul. Filtrowa 68 128 Keitel Roland +49 69 66 90 2555 Lyonerstr. 34 129 Mini Wheels Co. Murphy Julie 6505555787 5557 North Pendale Street 131 Lee Kwai 2125557818 897 Long Airport Avenue 141 Freyre Diego (91) 555 94 44 C/ Moralzarzal, 86 144 Berglund Christina 0921-12 3555 Berguvsvgen 8 145 Petersen Jytte 31 12 3555 Vinbaeltet 34 146 land of Toys Inc Euro+ Shopping Channel Volvo Model Replicas, Co Danish Wholesale Imports Saveley & Henriot, Co. Dragon Souveniers, Ltd. Muscle Machine Inc Diecast Classics Inc. Technics Stores Inc. Saveley Mary 78.32.5555 2, rue du Commerce 148 Natividad Eric +65 221 7555 Bronz Sok Bronz Apt. 3/6 Tesi 151 Young Jeff 2125557413 4092 Furth Circle Suite 400 157 Leong Kelvin 2155551555 7586 Pompton St. 161 Hashimoto Juri 6505556809 9408 Furth Circle 166 Handji Gifts & Co Victorino Wendy +65 224 1555 106 Linden Road Sandowns 2nd Floor 167 Herkku Gifts Oeztan Veysel +47 2267 3215 Brebmen St. 121 PR 14 Sentrum 168 American Souvenirs Inc Franco Keith 2035557845 149 Spinnaker De Suite 101 169 de Castro Porto Imports Co. Daedalus Designs Imports Isabel (1) 356-5555 Estrada da sade n. 58 171 Rance Martine 20.16.1555 184, chausse de Tournai Using the supplied ERD for the database assignment, correctly identify the relationships between the tables presented below: A product belongs to product line(s) Choose... A customer may place order(s) Choose... An order contains order detail(s) Choose... A payment is made by customer(s) Choose... An employee works out of office(s) Choose... Complete the query below so that it returns the order numbers for all orders purchased by customer number 129 (there should matched records) SELECT FROM orders - 129; Complete the query below so that it returns the average MSRP for the company's plane products (should round to 89.52). SELECT (msrp) FROM products WHERE Complete the query below so that it returns the customer number and payment date for payments made for $100,000 and over in 20 (which means that orders that equal $100,000 should be included in the range), Should return 2 records. SELECT customer_number, payment_date, amount FROM payments WHERE amount 100000 payment_date 2019-12-31