MySQL 8.0

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

CREATE TABLE if not exists User (
    id bigint AUTO_INCREMENT,
    coins bigint not null,
    level bigint not null,
    country VARCHAR(128),
    PRIMARY KEY (id)
);
INSERT INTO User (coins, level, country)
WITH RECURSIVE
  cte (id) AS (SELECT 1 UNION ALL SELECT id + 1 FROM cte LIMIT /* 3000000 */ 30)
SELECT
    FLOOR(RAND() * 100000) AS coins,
    FLOOR(RAND() * 100 + 1) AS level,
    ELT(RAND() * 4 + 1, "SPAIN", "FRANCE", "UK", "USA", "GERMANY")
FROM cte;

Records: 30  Duplicates: 0  Warnings: 0


SELECT * FROM User;


id
coins
level
country


1
91964
21
FRANCE

2
66568
57
USA

3
42424
66
GERMANY

4
96600
88
UK

5
82593
66
USA

6
99248
60
GERMANY

7
9879
58
UK

8
10643
84
USA

9
84696
62
UK

10
88319
78
FRANCE

11
78777
28
GERMANY

12
17600
89
GERMANY

13
81027
38
UK

14
6968
4
GERMANY

15
69708
61
GERMANY

16
88515
61
FRANCE

17
99155
88
UK

18
42517
90
FRANCE

19
24221
67
UK

20
89733
76
SPAIN

21
24718
93
USA

22
54690
15
SPAIN

23
7810
8
FRANCE

24
48199
99
UK

25
45058
81
USA

26
3323
10
FRANCE

27
49314
41
UK

28
55390
11
USA

29
99730
40
SPAIN

30
82926
13
FRANCE

id	coins	level	country
1	91964	21	FRANCE
2	66568	57	USA
3	42424	66	GERMANY
4	96600	88	UK
5	82593	66	USA
6	99248	60	GERMANY
7	9879	58	UK
8	10643	84	USA
9	84696	62	UK
10	88319	78	FRANCE
11	78777	28	GERMANY
12	17600	89	GERMANY
13	81027	38	UK
14	6968	4	GERMANY
15	69708	61	GERMANY
16	88515	61	FRANCE
17	99155	88	UK
18	42517	90	FRANCE
19	24221	67	UK
20	89733	76	SPAIN
21	24718	93	USA
22	54690	15	SPAIN
23	7810	8	FRANCE
24	48199	99	UK
25	45058	81	USA
26	3323	10	FRANCE
27	49314	41	UK
28	55390	11	USA
29	99730	40	SPAIN
30	82926	13	FRANCE