How to display correctly mysql results?

Question

MySQL

Hello, the essence is this, there is a table in it there is a type column that can have the value win and lose. Need to display the amount of win after lose

Answer 1

SELECT COUNT(*) FROM <tablename> 
WHERE `type` = 'win' AND <id_fieldname> > 
(SELECT MAX(<id_fieldname>) FROM  <tablename> WHERE `type` = 'lose')