Question: Objective: To practice creating a stored procedure, and think through how these are time savers for analysts working with large amounts of data. Instructions: Using

Objective: To practice creating a stored procedure, and think through how these are time savers for analysts working with large amounts of data. Instructions: Using your ClassicModels database, create stored procedures that generate calculations and answer the questions. Q1: Create a stored procedure that finds the average price of all of the models sold. (Hint: use the variable priceEach) Q2: Create a stored procedure that returns the customer who has had the largest purchase. Q3: As a business analyst, what are two (2) other stored procedures that would be helpful for you to run on a regular basis to provide insights into sales and inventory performance? (You do not need to write out the stored procedures in SQL but list them and explain why in 3-5 sentences.) Q4: After learning about SQL Injection Attacks, how might a stored procedure be used not just for data analysis but also for security and auditing purposes? (8-10 sentences)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!