Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- In all requests I change in names of tables and names of columns " " -> "_" (for example Bet ID -> Bet_ID)
- CREATE TEMP TABLE status AS
- SELECT Player_ID,
- CASE
- WHEN Player_level = 1 THEN 'Norm'
- WHEN Player_level = 2 THEN 'High value'
- WHEN Player_level = 3 THEN 'VIP'
- ELSE 'no_info'
- END AS player_status
- FROM Players;
Add Comment
Please, Sign In to add comment