All Tracks Problem

Micro and Assignment
Tag(s):

Muy fácil, Very-Easy, とてもやさしい, 非常に簡単, 非常简单

Problem
Editorial
Analytics

Given a table "Users", having username and date of birth (dob) of several users, find out all the users who were born in a leap year. Print the output in increasing order of date of birth. If two users have same date of birth print in decreasing order of their usernames. Print date of birth in "DD-Mon-YYYY" format. Check sample input, output for more clarity.

Input Format

There is only table that you have to use. The schema of the table is as given below.

Table : Users

Field Type
username text
dob date

Output Format

Field Type
username text
dob date

Sample Explanation

Sample Users table:

username dob
paul 1996-11-30
bob 2000-01-01
alice 2000-01-01
sherlock 1999-02-04
watson 1998-03-01

Sample Output:

username dob
paul 30-Nov-1996
bob 01-Jan-2000
alice 01-Jan-2000
Time Limit: 1 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