Transforming Columns with String Manipulation

Transform the names of employees into slug format. This means converting all characters to lowercase and replacing spaces with hyphens. For example, the name "John Doe" should become "john-doe".

Table Used:

• Employee

Final Columns to Display:

• "EmployeeId"
• "NameSlug" (The employee's name transformed into slug format)

Order By:
The output should be ordered by "EmployeeId".

Note that it's essential to use the exact table and column names as specified. Pay special attention to the column names and their casing. To ensure clarity, the column and table names are enclosed in double quotes whenever possible.

Good luck, and happy querying!