SQL Quiz
10 questions · no time limit
0:00
WINDOW FUNCTIONS
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
A
payments table contains four rows for one account, ordered by payment_date: amounts 20, 35, 10, and 40. The dates are unique.The following expression is evaluated for each row:
SUM(amount) OVER (ORDER BY payment_date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW)
What value is returned for the fourth payment? YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end