All Tracks Problem

Users and Ratings
Tag(s):

Medium, Médio, 中等, 普通

Problem
Editorial
Analytics

Hakerearth has a big database of users which have different ratings, levels (can be between 1 to 10 inclusive) and belongs to different countries. Once a developer in Hackerearth faced an interesting query. He needs to find all the users and their ratings, who have ratings greater than the ratings of all the Special users.

Special Users are the ones who belongs to those countries which contain the Users with level 4, 7 or 9. Help her find all the required users. For better understanding of the problem, refer to the sample explanation given below.

Input Format

Table : Details

Field Type
Username text
Ratings int
Level int
Country text

Sample

Sample Students table:

Username Ratings Level Country
NXPGEOVCMN 185 10 Australia
BOXVQWUVTX 85 7 Afghanistan
QBMNSPLSGQ 15 4 Andorra
ZCGCRNYEMJ 16 9 Antigua

Output

Username Ratings
NXPGEOVCMN 185
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