$(5$ marks$)$ Write a query to print the hacker$\_$id$,$ name, and the number of distinct tasks each hacker

participated in$.$ Sort the result by the number of tasks in descending order, and then by hacker$\_$id in ascending

order if there$$s a tie.

$2.(5$ marks$)$ Write a query to find the task$\_$id$,$ description, and the total bonus awarded for each task. Sort the

result by task$\_$id in ascending order.

$3.(5$ marks$)$ Write a query to list the submission$\_$id$,$ hacker$\_$id$,$ name, and score of the highest$-$scoring

submission for each task submitted on $2023-01-01.$ If multiple submissions have the highest score for the same

task, return the submission with the smallest submission$\_$id$.$ Sort the result by task$\_$id in ascending order.

$4.(5$ marks$)$ Write a query to print the hacker$\_$id$,$ name, and the total score each hacker achieved across all

tasks. For each task, only the hacker's best score counts. Sort the result by total$\_$score in descending order and

by hacker$\_$id in ascending order if there's a tie.

$5.(5$ marks$)$ Write a query to find the hacker$\_$id$,$ name, and bank$\_$account of hackers who did not participate in

any tasks.