I cannot get this SQL code to run, I keep getting the "," syntax error. I need to use CASE scenario. I want to take customers (column is name) and their total purchases (column is price) and sum them. Anything equal to or greater than $10000 is Gold. Anything equal to or greater than 5000, but less than 10000 is silver, and anything else is Bronze. The Gold, Silver and Bronze answers should be identified as loyalty tier
SELECT
Name,
SUM(price),
CASE
WHEN total_price >= 10000 THEN ‘Gold’,
WHEN total_price >= 5000 AND <10000 THEN ‘SiLVER’,
ELSE ‘Bronze’
END AS [loyalty_tier]
FROM
Sales;
