Northeastern Representation of Data Points Over a Period of Time Sqlda Database
Question Description
Exercise 22: Time Series Analysis
First, using the sqlda database, show the number of monthly sales. Then find the number of new customers joining each month. Then using R or Python generate a graph with lines showing the number of monthly sales and the monthly growth of customers. Submit a Word document with screen shots included of your successful queries and the visualization. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.
Exercise 23: Distance calculations.
First, create a temporary table with latitude and longitude points for every customer. Eliminate those customers whose address is unknown. Do the same for the dealerships. Then, create a table which shows the distance from each customer to each dealer in ascending order. For each customer, find the closest dealer. Submit a Word document with screen shots documenting your solutions the closest dealer problem. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.
Exercise 24: JSONB Search
Using sqlda, find ten customers who purchased a Blade scooter. Use JSONB_PRETTY to make the output readable. Submit a Word document with a screenshot of the solution. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.
Exercise 25: Text Analytics
Using sqlda, do exercise 25 in the text. In step 3 make sure that you only have one space between the quotation marks in the SELECT query. The text shows multiple spaces but that is the element that the parser works on. It will parse on the number of spaces you give it and there should only be one space between words. In step 4, use the Round() function to limit the rating to 2 decimal places. Also, order the ratings so that the highest ratings are at the top of the results. Submit a Word document with a screenshot of the output from Step 4. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.
Activity 9: Sales Search
Using sqlda, complete Activity 9 in the book. Answer the question “how often does a customer buy both a scooter and an automobile”. Order from highest to lowest. Submit a Word document with a screenshot of the solution. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
