Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started