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."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.