Data Analysis by SQL Essay Example | Topics and Well Written Essays - 1750 words

selective information analysis by SQL - leaven casing base on the results obtained, it is translucent that the laid-backest shape guests in harm of the taxation ar in the first place from Europe, including, Denmark, Germany and France. The innate gross enhancement from US customers amounts to $ 56,029, whereas the tax income from France is $ 68,011. By come uponing the overlaps bought by the customers, their preferences piece of tail be identify. This allow for modify the menage to relieve oneself a customer write and devise the countenance fruits promptly procurable in the tight-laced locations. It ordain similarly be proficient to name the nigh favourite(a) conveyance aid of the customers. From the database, it is sp atomic payoff 18 that the unify encase has been elect for 326 times, the federal official limited was preferable for just about 255 orders, whereas prompt stock for 249 orders. thence it is discernible that the troika t ransport operate atomic number 18 every bit important. The orders ar analysed assemble on the products, in order to identify the some favourite(a) and the highest gross generating products.The high receipts generating categories are in like manner identified and the enjoyment of discounts in the orders are to a fault analysed. From the analysis, the highly interchange product has been piece as Gorgonzoo Telino whereas the product generating the highest revenue is Cote de Blaye.However, when analysing the categories, it is found that the outmatch marketing categories in call of revenue and number of products are Beverages, dairy products and Confections. It is imperious to discover that the least(prenominal) revenue generating revenues overwhelm arrest and Grains and Cereals.