Easy, 简单, 簡単

Problem

Editorial

Analytics

Hackerearth wants to give some goodies to the User with maximum ratings of each country in its database. The details are required for the same. To send goodies, the name of the user, its country and its ratings are required. The data should be sorted according to the Country's name.

Input Format:

Table : Details

Field	Type
Name	text
Country	text
Rating	int

Output Format:

Field	Type
Name	text
Country	text
Rating	int

Sample Input:

Sample Details Table:

Name	Country	Rating
Aj	India	2400
Jaimi	India	2500
Gennay	Russia	3200
Petry	Russia	3100

Sample Output:

Name	Country	Rating
Jaimi	India	2500
Gennay	Russia	3200

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 Database

CODE EDITOR

Initializing Code Editor...

All Tracks Problem