Ryan_Chynoweth
Databricks Employee
Databricks Employee

The correct syntax would be:

SELECT 'Goal' AS Type, Value 
FROM table