How to select 2 values ​​from 2 parameters and display them on 1 line?

Question

SQL

Good day, how can I get 2 parameters in 1 request and display their values ​​on 1 line?

SELECT user.id, user.nickname, stat.param, stat.value FROM saved_users_stats AS stat
JOIN saved_users AS user ON userId = id
WHERE param = "[difficulty]chernobylhard [mode]PVE [stat]player_sessions_won" ORDER BY value DESC LIMIT 50

database structure and

query output

Is it possible to get the example structure:
id nickname won lost?

Answer 1

Making a PIVOT

select 
  user_id,
  sum(case when param = 'Won' then value else 0 end) 'Won',
  sum(case when param = 'Lose' then value else 0 end) 'Lose'
from user_stats
where param in ('Won', 'Lose')
group by user_id;

SQL PIVOT online