SQL exercises for a Finance database:

a. Write a SELECT statement that returns two columns: Date and IntraDayChange defined as the difference between [Close] and [Open] for Ticker = DJI where this difference is larger than $500.00. Make sure to format your output nicely and present the result set in the descending order of the Intra-day change.

b. Repeat exercise a., this time return all records where the absolute value of IntradayChange was greater than $500.00c. Write a SELECT statement that returns two columns: Date and IntraDayRange defined as the difference between [High] and [Low] for Ticker = DJI where this difference is larger than $500.00. Make sure to format your output nicely and present the result set in the descending order of the Intra-day range.d. Combine queries a. and

c.: Write a SELECT statement that returns Three columns: Date,IntraDayChange , and IntraDayRange for Ticker = DJI where IntraDayRange is larger than $500.00. Make sure to format your output nicely and present the result set in the descending order of the Intra-day range.

d. Combine queries a. and c.: Write a SELECT statement that returns Three columns: Date,IntraDayChange , and IntraDayRange for Ticker = DJI where IntraDayRange is larger than $500.00. Make sure to format your output nicely and present the result set in the descending order of the Intra-day range.