(Answer all of the questions with a thumb up) (Using SQL Oracle to write). Tks

300% View Zoom Add Page Insert Table Chart Text Shape Media Commen Collaborate Format Docume 1. Create a query that shows employee number, first name, last name, city, phone number and postal code for all employees in France. Sort the result by Employee Number. a. Answer this question using an ANSI-89 Join b. Answer this question using an ANSI-92 Join 1 2 EMPLOYEENUMBER FIRSTNAME LASTNAME CITY PHONE POSTALCODE 1102 Gerard Bondur Paris +33 14 723 4404 75017 1337 Loui Bondur Paris +33 14 723 4404 75017 1370 Gerard Hernandez Paris +33 14 723 4404 75017 1401 Pamela Castillo Paris +33 14 723 4404 75017 1702 Martin Gerard Paris +33 14 723 4404 75017 3 4 5 300% Zoom c Insert Table Chart Text Shape Media Comment View Add Page Collaborate Format Document 2. Create a query that displays all payments made by customers from Canada. a. Sort the output by Customer Number. b. Only display the Customer Number, Customer Name, Payment Date and Amount. C. Below is just a sample data to match the Column Headings (proper case) and the Date Format. The Date Format must match below sample. There should be about 273 records in your result set. 1 2 3 4 5 6 Customer Number Customer Name 103 Atelier graphique 103 Atelier graphique 103 Atelier graphique 112 Signal Gift Stores 112 Signal Gift Stores 112 Signal Gift Stores 114 Australian Collectors, Co. 114 Australian Collectors, Co. 114 Australian Collectors, Co. 114 Australian Collectors, Co. Payment Date Amount Oct 19, 2004 6066.78 Jun 05, 2003 14571.44 Dec 18, 2004 1676.14 Dec 17, 2004 14191.12 Jun 06, 2003 32641.98 Aug 20, 2004 33347.88 May 20, 2003 45864.03 Mar 10, 2004 44894.74 May 31, 2003 7565.08 Dec 15, 2004 82261.22 . 7 8 9 10 300% Zoom View Add Page Insert Table Chart Text Shape Media Comment Collaborate Format Document 3. Create a query that shows all USA customers who have not made a payment. Display only the customer number and customer name sorted by customer number. Below is 10 out of 35 records in the result set. 1 2 3 4 5 Customer Number Customer Name 112 Signal Gift Stores 124 Mini Gifts Distributors Ltd. 129 Mini Wheels Co. 131 Land of Toys Inc. 151 Muscle Machine Inc 157 Diecast Classics Inc. 161 Technics Stores Inc. 173 Cambridge Collectables Co. 175 Gift Depot Inc. 181 Vitachrome Inc. 6 7 8 9 10 300% (9 Chart c Text Shape Media Comment View Zoom Add Page Insert Table Collaborate Format Document 4. a) Create a view (vwCustomerOrder) to list all orders with the following data for all customers: Customer Number, Order Number, Order Date, Product Code, Product Name, Quantity Ordered, and Price for each product in every order. b) Write a statement to view the results of the view just created. c) Sample result set displays 10 out of 2996 records. 2 3 4 5 CUSTOMERNUMBER ORDERNUMBER ORDERDATE PRODUCTNAME 151 10127 03-JUN-03 1969 Corvair Monza 151 10127 03-JUN-03 1969 Ford Falcon 151 10127 03-JUN-03 1957 Chevy Pickup 151 10127 03-JUN-03 1998 Chrysler Plymouth Prowler 151 10127 03-JUN-03 1964 Mercedes Tour Bus 151 10127 03-JUN-03 1992 Ferrari 360 Spider red 151 1012703-JUN-03 1970 Triumph Spitfire 151 1012703-JUN-03 1970 Dodge Coronet 151 10127 03-JUN-03 1958 Chevy Corvette Limited Edition 151 10127 03-JUN-03 1992 Porsche Cayenne Turbo Silver QUANTITYORDERED PRICEEACH 46 140.5 42 169.56 24 100.73 45 140.81 45 114.14 22 149.02 25 126.39 20 50.86 39 34.3 20 107.63 6 9 10 300% Zoom c Text Shape Media Comment View Add Page Insert Table Chart Collaborate Format Document 5. Using the vwCustomerOrder view, display the order information for customer number 124. Sort the output based on order number and then order line number. (Yes, I know orderline Number is not in the view). 10 out of 180 records are displayed within below sample result set. 1 2 3 4 5 6 2 8 9 CUSTOMERNUMBER ORDERNUMBER ORDERDATE ORDERLINENUMBER PRODUCTCODE PRODUCTNAME QUANTITYORDERED PRICEEACH 124 10113 26-MAR-03 1532 3522 1996 Peterbilt 379 Stake Bed with Outrigger 23 58.82 124 10113 26-MAR-03 2 812 1666 1958 Setra Bus 21 121.64 124 10113 26-MAR-03 3 818 4668 1939 Cadillac Limousine 50 43.27 124 10113 26-MAR-03 4818 1097 1940 Ford Pickup Truck 49 101.5 124 10135 02-JUL-03 1 S24 2972 1982 Lamborghini Diablo 20 34.36 124 10135 02-JUL-03 2 524 3856 1956 Porsche 356A Coupe 47 139.03 124 10135 02-JUL-03 3818 1889 1948 Porsche 356-A Roadster 48 66.99 124 10135 02-JUL-03 4 512 4675 1969 Dodge Charger 29 103.64 124 10135 02-JUL-03 5 S12 3380 1968 Dodge Charger 48 110.39 124 10135 02-JUL-03 6 S24 3371 1971 Alpine Renault 1600s 27 52.05 10 6. Create a query that displays the customer number, customer name, contact first name, contact last name, phone, and credit limits for all customers who do not have any orders. 300% v Zoom T Insert Table Chart Text Shape Media Comment View Add Page Callaborate Format Document 1 2 3 5 6 6 7 8 9 10 11 12 CUSTOMERNUMBER CUSTOMERNAME CONTACTFIRSTNAME CONTACTLASTNAME PHONE CREDITLIMIT 335 Cramer Spezialitten, Ltd Philip Cramer 0555-09555 0 348 Asian Treasures, Inc. Patricia McKenna 2967 555 356 SAR Distributors, Co Armand Kuger +27 21 550 3555 0 361 Kommission Auto Karin Josephs 0251-555259 0 369 Lisboa Souveniers, Inc Lino Rodriquez (1) 354-2555 0 376 Precious Collectables Braun Urs 0452-076555 0 409 Stuttgart Collectable Exchange Rita Mller 0711-555361 0 443 Feuer Online Stores, Inc Alexander Feuer 0342-555176 0 459 Warburg Exchange Sven Ottlieb 0241-039123 465 Anton Designs, Ltd. Carmen Anton +34 913 728555 477 Mit Vergngen "&" Co. Hanna Moos 0621-08555 480 Kremlin Collectables, Co. Alexander Semenov +7 812 293 0521 481 Raanan Stores, Inc Raanan Altagar,GM + 972 9 959 8555 125 Havel "&" Zbyszek Co Zbyszek Piestrzeniewicz (26) 642-7555 168 American Souvenirs Inc Keith Franco 2035557845 169 Porto Imports Co. Isabel de Castro (1) 356-5555 206 Asian Shopping Network, Co Brydey Walker +612 9411 1555 223 Natrlich Autos Horst Kloss 0372-555188 0 237 ANG Resellers Alejandra Camino (91) 745 6555 247 Messner Shopping Network Renate Messner 069-0555984 273 Franken Gifts, Co Peter Franken 089-0877555 293 BG"&"E Collectables Ed Harrison +41 26 425 50 01 303 Schuyler Imports Bradley Schuyler +31 20 491 9555 307 Der Hund Imports Mel Andersen 030-0074555 13 14 15 16 17 18 19 20 21 22 23 24