Skip to content
Advertisement

find total unique number of hackers who made at least one submission every day and find the hacker_id who made maximum number of submissions each day

Find total number of unique hackers who made at least submission each day (starting on the first day of the contest), and find the hacker_id and name of the hacker who made maximum number of submissions each day. If more than one such hacker has a maximum number of submissions, print the lowest hacker_id. The query should print this information for each day of the contest, sorted by the date.

Here is the sample data: Hackers table:

My below query doesnt give me unique hacker_ids

How do I get the unique hacker_ids in the above results ?

Advertisement

Answer

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement