Result: near “Type”: syntax error
At line 2:
SELECT
InvoiceDate,
BillingAddress,
BillingCity,
total,
CASE
WHEN total < 2.00 THEN ‘Baseline Purchase’
ELSE ‘Top Performer’
END AS Purchase Type
FROM
Invoice
WHERE
Purchase Type = ‘Top Performer’
ORDER BY
BillingCity
New contributor
Ankit Bhalerao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.