Given this simple scenario, answer the following questions regarding the tables and graphs provided below: 1. Prepare R scripts using dplyr package to produce the tables (Table 1 & Table 2). 2. Discuss briefly if you have found R scripts are easier than sql query statement? Explain why, or why not? 3. Table 1: Top 10 Products by Quantity of Product Ordered product Name product Code productVendor SumOfQuantityOrdered 1808 1111 1085 1076 1074 1992 Ferrari 360 Spider red S18_3232 Unimax Art Galleries 1937 Lincoln Berline S18_1342 Motor City Art Classics American Airlines: MD-115 S700_4002 Second Gear Diecast 1941 Chevrolet Special Deluxe S18_3856 Exoto Designs Cabriolet 1930 Buick Marquette Phaeton S50_1341 Studio M Art Models 1940s Ford truck S18_4600 Motor City Art Classics 1969 Harley Davidson Ultimate 510_1678 Min Lin Diecast Chopper 1957 Chevy Pickup 512_4473 Exoto Designs 1964 Mercedes Tour Bus S18_2319 Unimax Art Galleries 1956 Porsche 356A Coupe S24_3856 Classic Metal Creations Note: Sum OfQuantityOrdered is the total quantity of each product ordered. 1061 1057 1056 1053 1052 Table 2: Top 10 Customers by Total Amount of All Orders customer Number customerName city country Amount 820689.5 591827.3 180585.1 141 Euro+ Shopping Channel Madrid Spain 124 Mini Gifts Distributors Ltd. San Rafael USA 114 Australian Collectors, Co. Melbourne Australia 151 Muscle Machine Inc NYC USA 119 La Rochelle Gifts Nantes France 148 Dragon Souveniers, Ltd. Singapore Singapore 323 Down Under Souveniers, Inc Auckland New Zealand 131 Land of Toys Inc. NYC USA 187 AV Stores, Co. Manchester UK 450 The Sharp Gifts Warehouse San Jose USA Note: Amount is the total dollar amount of all orders that each customer has made. 177914 158573.1 156251 154622.1 149085.2 148410.1 143536.3 Given this simple scenario, answer the following questions regarding the tables and graphs provided below: 1. Prepare R scripts using dplyr package to produce the tables (Table 1 & Table 2). 2. Discuss briefly if you have found R scripts are easier than sql query statement? Explain why, or why not? 3. Table 1: Top 10 Products by Quantity of Product Ordered product Name product Code productVendor SumOfQuantityOrdered 1808 1111 1085 1076 1074 1992 Ferrari 360 Spider red S18_3232 Unimax Art Galleries 1937 Lincoln Berline S18_1342 Motor City Art Classics American Airlines: MD-115 S700_4002 Second Gear Diecast 1941 Chevrolet Special Deluxe S18_3856 Exoto Designs Cabriolet 1930 Buick Marquette Phaeton S50_1341 Studio M Art Models 1940s Ford truck S18_4600 Motor City Art Classics 1969 Harley Davidson Ultimate 510_1678 Min Lin Diecast Chopper 1957 Chevy Pickup 512_4473 Exoto Designs 1964 Mercedes Tour Bus S18_2319 Unimax Art Galleries 1956 Porsche 356A Coupe S24_3856 Classic Metal Creations Note: Sum OfQuantityOrdered is the total quantity of each product ordered. 1061 1057 1056 1053 1052 Table 2: Top 10 Customers by Total Amount of All Orders customer Number customerName city country Amount 820689.5 591827.3 180585.1 141 Euro+ Shopping Channel Madrid Spain 124 Mini Gifts Distributors Ltd. San Rafael USA 114 Australian Collectors, Co. Melbourne Australia 151 Muscle Machine Inc NYC USA 119 La Rochelle Gifts Nantes France 148 Dragon Souveniers, Ltd. Singapore Singapore 323 Down Under Souveniers, Inc Auckland New Zealand 131 Land of Toys Inc. NYC USA 187 AV Stores, Co. Manchester UK 450 The Sharp Gifts Warehouse San Jose USA Note: Amount is the total dollar amount of all orders that each customer has made. 177914 158573.1 156251 154622.1 149085.2 148410.1 143536.3
