So you mean
level
is not a field?
On this point, you need to use a
SELECT CASE
statement to meet your desired output. Here, try this:
SELECT name
,age
,gender
,'level' = CASE
WHEN points <= 499 THEN 'newbie'
WHEN points >= 500 THEN 'expert'
ELSE 'unknown'
END
FROM [TableName]
Regards,
Eduard