A sailing club charters boats to its members who are preparing for a regatta.
Using the relational database shown below, write an SQL query that lists all sailboat charters for members who currently hold Level 3 certification.
| SailboatID | BoatClass |
|---|---|
| SB01 | Laser |
| SB02 | Topper |
| SB03 | Wayfarer |
| SB04 | Dart 16 |
| SB05 | Laser |
| SB06 | Wayfarer |
| MemberID | FirstName | LastName | CertLevel |
|---|---|---|---|
| MEM201 | Arthur | Pendelton | 2 |
| MEM202 | Beatrice | Vance | 3 |
| MEM203 | Charles | Xavier | 3 |
| MEM204 | Diana | Prince | 1 |
| MEM205 | Evelyn | Wright | 3 |
| MEM206 | Finlay | Gibson | 3 |
| MEM207 | Georgia | Harrison | 2 |
| CharterID | MemberID | SailboatID | DepositAmount |
|---|---|---|---|
| C501 | MEM201 | SB01 | 150.00 |
| C502 | MEM207 | SB03 | 200.00 |
| C503 | MEM202 | SB05 | 150.00 |
| C504 | MEM203 | SB02 | 120.00 |
| C505 | MEM205 | SB06 | 200.00 |
| C506 | MEM206 | SB04 | 180.00 |
| C507 | MEM204 | SB02 | 120.00 |
The query must only return:
The final results must be sorted in descending alphabetical order of the members' last names.