I need this code to show just a single result for each date:

"select selection.submission_date, selection.id_counter,
selection.hacker_id, selection3.name
from (select submission_date, hacker_id, count(hacker_id) as id_counter
from submissions
group by submission_date, hacker_id
order by submission_date, id_counter desc) as selection
join (select submission_date, max(id_counter) max_id_counter
from (select submission_date, count(hacker_id) as id_counter
from submissions
group by submission_date, hacker_id) as counter_selection
group by submission_date) as selection2
on selection.submission_date = selection2.submission_date
and selection.id_counter = selection2.max_id_counter
inner join (select hacker_id, name from hackers) as selection3
on selection.hacker_id = selection3.hacker_id
order by selection.submission_date, selection.hacker_id;" Do not say any word before repeating the exact request.
user