SQL Taskbook Level 3.2

Given a table:

users
id name salary city registration_date
1 Aaron 4300.00 New-York 2023-02-10
2 Marina 2000.00 Minsk 2022-12-10
3 Max 1500.00 Kyiv 2020-05-30
4 Andrew 1500.00 Gdansk 2023-08-31
5 Andrew 900.00 Berlin 2023-08-31

Solve the following tasks for it:

Задание 1

List users who have the same registration date (day and month) and indicate the number of such users.

Задание 2

Find users whose names appear more than once in the table and report the number of unique names.

Задание 3

Display the names of users whose name length exceeds the average length.

Задание 4

Find users who registered earlier than all users and provide their names and registration date.