How to make SQL Pivot Table in Databricks with dataset table view?

I am trying to make a Pivot Table with SQL. This is the sample data that I am using. And I am trying to make the Survey Result Levels (1,2,3,4) as the column headings and the count of the results as the rows.

This is how the sample data looks in excel

This is the code that I have used, I tried to imitate it from Microsoft Website, but it is not working.

SELECT *
FROM (
    SELECT 'JobSatisfaction' as Level, [1], [2], [3], [4]
    FROM employees_survey_data
   )as SourceTable
PIVOT(
   COUNT(EmployeeID)
   FOR JobSatisfaction IN ([1], [2], [3], [4])
  ) as PivotTable

Please tell me what I am doing wrong, and how I can fix it. Thank you for your time.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum