Alexander_89

m1

Sep 7th, 2025
34
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.33 KB | None | 0 0
  1. -- In all requests I change in names of tables and names of columns " " -> "_" (for example  Bet ID -> Bet_ID)
  2. CREATE TEMP TABLE status AS
  3. SELECT Player_ID,
  4. CASE
  5.     WHEN Player_level = 1 THEN 'Norm'
  6.     WHEN Player_level = 2 THEN 'High value'
  7.     WHEN Player_level = 3 THEN 'VIP'
  8.     ELSE 'no_info'
  9. END AS player_status
  10. FROM Players;
  11.  
Add Comment
Please, Sign In to add comment