MySQL 8.0

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

CREATE TABLE hi_priority
(
  id INT UNSIGNED AUTO_INCREMENT,
  name VARCHAR(255),
  col1 VARCHAR(255),
  col2 INT,

PRIMARY KEY(id)
);

CREATE TABLE lo_priority
(
  id INT UNSIGNED AUTO_INCREMENT,
  name VARCHAR(255),
  col1 VARCHAR(255),
  col2 INT,

PRIMARY KEY(id)
);

INSERT INTO hi_priority(name, col1, col2) VALUES('john', 'kl7y5tis4yh4', 1), ('john', 'tiid6iywq02k', 1), 
('john', 'detawgsxz615', 1), ('amy', 'i6u4hhc1trjk', 2), ('amy', 'wdpt0t5vtmbt', 2),
('amy', '87z5wgdfztwl', 2), ('amy', 'oj98jjdpb5yv', 2), ('steve', 'hllaazonflf0', 3),
('steve', '0h22y66kq3ow', 3), ('steve', 'o04ksti7di60', 3), ('steve', '3qlylbzqfr51', 3),
('steve', 'wmisshywtb12', 3), ('bob', 'ku8wpf7d6ta9', 3), ('bob', '6t7mn60g0g18', 3),
('bob', 'qv0s7ho3jku6', 3), ('bob', '5qgz7dznzwvn', 3), ('bob', 'mm76nhimm6fu', 3),
('bob', 'k7nlpksc55t2', 3), ('oliver', 'gvf9kjewpj7h', 4), ('oliver', '24w5s30w5te6', 4);

INSERT INTO lo_priority(name, col1, col2) VALUES('doug', 'j205tzrsfmax', 11), ('doug', '0w7rcazbh6es', 11),
('doug', '6xswf8frsjaw', 11), ('john', 'iw7d14vtysz2', 2), ('john', '6lg667dygaz1', 2),
('john', '83uk5dcobpu5', 2), ('john', 'tl8cpzatv0n9', 2), ('mike', '2dsarwozpmci', 3),
('mike', 'hinn6w03wdib', 3), ('mike', '4sxbgyacmjob', 3), ('mike', 'm4q13ln9gctj', 3),
('mike', 'pnip9c8cejo9', 3), ('steve', 'faff9p9v96x4', 4), ('steve', 'd5mxqpd3k8zi', 4),
('martha', 'bxggn5t6d2xn', 8), ('martha', 't05mi47i4n6l', 8), ('martha', 'p30wmw2o6nty', 8),
('martha', 'wip6efajt9yv', 8);

Records: 20  Duplicates: 0  Warnings: 0

Records: 18  Duplicates: 0  Warnings: 0

id	name	col1	col2
1	john	kl7y5tis4yh4	1
2	john	tiid6iywq02k	1
3	john	detawgsxz615	1
4	amy	i6u4hhc1trjk	2
5	amy	wdpt0t5vtmbt	2
6	amy	87z5wgdfztwl	2
7	amy	oj98jjdpb5yv	2
13	bob	ku8wpf7d6ta9	3
14	bob	6t7mn60g0g18	3
15	bob	qv0s7ho3jku6	3
16	bob	5qgz7dznzwvn	3
17	bob	mm76nhimm6fu	3
18	bob	k7nlpksc55t2	3
8	mike	2dsarwozpmci	3
9	mike	hinn6w03wdib	3
10	mike	4sxbgyacmjob	3
11	mike	m4q13ln9gctj	3
12	mike	pnip9c8cejo9	3
8	steve	hllaazonflf0	3
9	steve	0h22y66kq3ow	3
10	steve	o04ksti7di60	3
11	steve	3qlylbzqfr51	3
12	steve	wmisshywtb12	3
19	oliver	gvf9kjewpj7h	4
20	oliver	24w5s30w5te6	4
15	martha	bxggn5t6d2xn	8
16	martha	t05mi47i4n6l	8
17	martha	p30wmw2o6nty	8
18	martha	wip6efajt9yv	8