Write the following SQL statements to query the NDX table in the dbclass schema/

Question

Write the following SQL statements to query the NDX table in the dbclass schema/database. Your SQL statement should display only the columns identified unless otherwise specified.

1. Display the ChangeClose on the day Monday.

2. Display the average ChangeClose grouped by TYear and TMonth. Show both TYear, TMonth, and the averageChangeClose.

3. Optional Extra Credit - Display the average ChangeClose grouped by TYear, TQuarter, TMonth shown in ascending order of the calendar month. Show TYear, TQuarter, and TMonth. Note that months appear in alphabetical order not calendar order, you need to sort them by calendar order. Explain what you need to do to sort them by calendar order.

Explanation / Answer

1. Select ChangeClose from table NDX where TDay='Monday';

2. Select avg(ChangeClose), TYear, TMonth from NDX group by TYear, TMonth;

3. Select TYear,TMonth,TQuarter,avg(ChangeClose) from NDX group by TYear,TMonth,TQuarter order by field(month, January, February, March, April, May, June, July, August, September, October, November, December);

Field function is used to mention the order inorder to retrieve the results in the calender order.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.