SDEV1041SQLFinalProject
kevinbellr
What is the store’s average days for a customer to pay based on the return date of the film and the payment date. What is the customer’s average? Show a list of customer names, store id, customer’s average day to pay, and store’s average day to pay. Filter the results by customers that have an average days out greater than the stores average. Order the results by the customer ID. (Hint: stores have inventory, inventory have rentals, and rentals have payments.) Please add the function NOW() and give it a column name of your first name and last name separated by a underscore (this should be the first output column).
Growth over time
1 data points · 2021-08-06 → 2021-08-06How do you feel about this project?
Ask AI about SDEV1041SQLFinalProject
Question copied to clipboardWhat is the kevinbellr/SDEV1041SQLFinalProject GitHub project? Description: "What is the store’s average days for a customer to pay based on the return date of the film and the payment date. What is the customer’s average? Show a list of customer names, store id, customer’s average day to pay, and store’s average day to pay. Filter the results by customers that have an average days out greater than the stores average. Order the results by the customer ID. (Hint: stores have inventory, inventory have rentals, and rentals have payments.) Please add the function NOW() and give it a column name of your first name and last name separated by a underscore (this should be the first output column).". Written in TSQL. Explain what it does, its main use cases, key features, and who would benefit from using it.
Question is copied to clipboard — paste it after the AI opens.
How to clone SDEV1041SQLFinalProject
Clone via HTTPS
Clone via SSH
Download ZIP
Download master.zipFound an issue?
Report bugs or request features on the SDEV1041SQLFinalProject issue tracker:
Open GitHub Issues