I need an answer in SQL statement. Thank you

This is all I've got for tables, I need a code for the SQL.

Use formatting functions to generate a report that display employees last names, basic salary with local currency as a prefix (e.g. NZD), commission percentage, and commission value (Salary * Commission %). If there is no commission value, the report should display "No Commission" message. The output should be alphabetically sorted with respect to the last names as shown below