Welcome. Use the attached database and schema explorer to complete these tasks.
Task 1
Produce a list of all employees sorted by salary in descending order (highest earners first).
Task 2
Identify and display all employees currently assigned to the 'Apollo' project.
Task 3 (Complex)
Calculate the total project earnings for those on 'Apollo'. Assume pay occurs on the 1st and 15th of each month.
Requirement: Determine how many pay dates fall between the project start_date and end_date.