SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable (ID TEXT PRIMARY KEY, NAME TEXT, WINS INTEGER, LOSSES INTEGER, NOTES   TEXT);
✓
INSERT INTO mytable (ID, NAME, WINS, LOSSES, NOTES) VALUES 
  ('A001','John','1','0','blue'), ('A002','Mark','2','1','blue'), 
  ('A003','Hubert',null,null,'red'), ('A004','Otto','0','0','green'), 
  ('A005','Johnson','3','5','red'), ('A006','Frank',null,'1','green');
✓
WITH 
  cond AS (
    SELECT *,
           CASE
             WHEN WINS > 0 AND WINS <= 3 THEN 1
             WHEN WINS IS NULL OR WINS = 0 THEN 2 -- or WHEN COALESCE(WINS, 0) = 0 THEN 2
           END AS condition
    FROM mytable
    WHERE condition IN (1, 2)
  ),
  cte AS (SELECT *, ROW_NUMBER() OVER (PARTITION BY condition ORDER BY condition, WINS) rn FROM cond)
SELECT ID, NAME, WINS, LOSSES, NOTES
FROM cte
WHERE rn <= CASE condition 
        WHEN 1 THEN 3 -- x = 3
        WHEN 2 THEN 2 -- y = 2
      END
ORDER BY condition, WINS DESC;


ID
NAME
WINS
LOSSES
NOTES


A005
Johnson
3
5
red

A002
Mark
2
1
blue

A001
John
1
0
blue

A003
Hubert
null
null
red

A006
Frank
null
1
green

ID	NAME	WINS	LOSSES	NOTES
A005	Johnson	3	5	red
A002	Mark	2	1	blue
A001	John	1	0	blue
A003	Hubert	null	null	red
A006	Frank	null	1	green