Suppose We Are Given A View Tot Credits Year Num Credits Giving #409

Suppose we are given a view tot credits (year, num credits) giving the total number of credits taken by students in each year. The query that computes averages over the 3 preceding tuples in the specified sort order is

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 SQL: Queries, Constraints and Triggers - Recursive Queries and Aggregation Features - Quiz No.1.

 Select year, avg(num credits) over (order by year rows 3 preceding) as avg total credits from tot credits;

 Select year, avg(num credits) over (order by year rows 3 unbounded preceding) as avg total credits from tot credits;