Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

5 d) Create a query to show the name of the company whose price changed most
during the month of July and whose headquarters are in New York. (Hint: Use
the difference between the opening price in the first week of July and the
closing price in the last week of July, if July is not included in your data,
please use another month.)

Could you please help me to do this query in SQL view? Thank you !!!
 
Is this a class project or a final exam question?

What about if the price peaked in the middle of the month and then fell again?
 
Back
Top