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 _________

Suppose we are given a view tot credits (year, num credits) giving the

1.	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 _________
A.	SELECT YEAR, avg(num credits)
B.	SELECT YEAR, avg(num credits)
C.	SELECT YEAR, MIN(num credits)
D.	SELECT YEAR, SUM(num credits)
Answer» B. SELECT YEAR, avg(num credits)