Question: using VS SQL , write code for the following ( please elaborate for understanding of code ) : If there is more than $ 1

using VS SQL, write code for the following (please elaborate for understanding of code):
If there is more than $10,000.00?revenue (Total of Quantity X Price from the OrderDetails table) in 2017, display "Congratulations to LifeStyle LLC". Then find out exactly how many orders were placed in 2017? and what is their total value. Otherwise display "Try harder next year". Then include how many orders were placed in 2017? and their total value. Check to see if the code still works if a few larger orders are removed.

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!