Need to use this database: https://www.sqlitetutorial.net/sqlite-sample-database/
Need to use a mix of Python and SQL for these answers:
1- We need to promote 1 current employee to Sales manager within the store. Who should it be? Use the data available in the database to develop a way to measure the best candidate for the job and then make a recommendation. Use SQL and Python to complete task 1.1 and recommend an employee for promotion
2- The owner wants to know how often customers return to and purchase items at the store. Develop a histogram showing the frequency of time between visits. Use SQL and Python to complete task 1.2 and create the histogram (https://www.w3schools.com/python/matplotlib_histograms.asp recommended for use)
3- Develop 1 interest metric for this music store. For example, something that might be interesting and measureable could be the amount of money earned by the store/track/day. Use SQL and Python to complete task 1.3 and show the initial value of the metric that you chose
0 comments