All Tracks Problem

Little Shino and Clicks
Tag(s):

Very-Easy

Problem
Editorial
Analytics

A hacker from Byteland created a new website. He is keeping a count of number of clicks on each day on the website. He has the data of $$30$$ days (from 2016-01-26 to 2016-02-24) in a table Clicks.

For each date in the table he wants to count the total number of clicks from that day till 2016-02-24.

The output table should be in decreasing order of DateColumn.

Input Format:

Table : Clicks

Field Type
NumberOfClicks integer
DateColumn date

Output Format:

Field Type
NumberOfClicks integer
DateColumn date

Sample Input:

Sample Clicks Table:

NumberOfClicks DateColumn
35 2016-02-24
8 2016-02-23
11 2016-02-22
68 2016-02-21
0 2016-02-20

Sample Output:

NumberOfClicks DateColumn
35 2016-02-24
43 2016-02-23
54 2016-02-22
122 2016-02-21
122 2016-02-20
Time Limit: 5 sec(s) for each input file.
Memory Limit: 256 MB
Source Limit: 1024 KB
Marking Scheme: Marks are awarded when all the testcases pass.
Allowed Languages: MySQL, PostgreSQL, MSSQL, Oracle_Db

CODE EDITOR

Initializing Code Editor...
Your Rating:

Contributor

Notifications
View All Notifications