MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE user (user_id INT AUTO_INCREMENT PRIMARY KEY, user_name VARCHAR(255));
INSERT INTO user (user_name) VALUES ('John'), ('Jim'), ('Jane');
SELECT * FROM user;

Records: 3  Duplicates: 0  Warnings: 0




user_id
user_name


1
John

2
Jim

3
Jane


CREATE TABLE skill (skill_id INT AUTO_INCREMENT PRIMARY KEY, skill_name VARCHAR(255));
INSERT INTO skill (skill_name) VALUES
('PHP'), ('Laravel'), ('JavaScript'), ('Angular'), ('HTML');
SELECT * FROM skill;

Records: 5  Duplicates: 0  Warnings: 0




skill_id
skill_name


1
PHP

2
Laravel

3
JavaScript

4
Angular

5
HTML


CREATE TABLE user_skill (
  user_id INT NOT NULL,
  skill_id INT NOT NULL, 
  PRIMARY KEY (user_id, skill_id),
  FOREIGN KEY (user_id) REFERENCES user (user_id),
  FOREIGN KEY (skill_id) REFERENCES skill (skill_id),
  grade TINYINT NOT NULL,
  CHECK (grade BETWEEN 1 AND 5)
  );
INSERT INTO user_skill VALUES
(1,1,5),(1,2,3),(1,3,1),(1,4,1),(1,5,2),
(2,1,1),(2,2,3),(2,3,4),(2,4,5),(2,5,1),
(3,1,1),(3,2,1),(3,3,3),(3,4,4),(3,5,5);
SELECT user_name,
       MAX(CASE WHEN skill_name = 'PHP' THEN grade END) PHP,
       MAX(CASE WHEN skill_name = 'Laravel' THEN grade END) Laravel,
       MAX(CASE WHEN skill_name = 'JavaScript' THEN grade END) JavaScript,
       MAX(CASE WHEN skill_name = 'Angular' THEN grade END) Angular,
       MAX(CASE WHEN skill_name = 'HTML' THEN grade END) HTML
FROM user_skill
JOIN user USING (user_id)
JOIN skill USING (skill_id)
GROUP BY user_id;

Records: 15  Duplicates: 0  Warnings: 0




user_name
PHP
Laravel
JavaScript
Angular
HTML


Jane
1
1
3
4
5

Jim
1
3
4
5
1

John
5
3
1
1
2


CREATE TABLE criteria (
  user_id INT NOT NULL,
  FOREIGN KEY (user_id) REFERENCES user (user_id),
  skill_id INT NOT NULL, 
  FOREIGN KEY (skill_id) REFERENCES skill (skill_id),
  min_grade TINYINT NOT NULL,
  max_grade TINYINT NOT NULL,
  CHECK (min_grade <= max_grade),
  CHECK (min_grade >= 1),
  CHECK (max_grade <= 5)
  );
INSERT INTO criteria VALUES
(1,1,1,1), (1,2,1,5), (1,3,4,5), (1,4,4,5), (1,5,1,5);
SELECT user_name,
       MAX(CASE WHEN skill_name = 'PHP' THEN min_grade END) min_PHP,
       MAX(CASE WHEN skill_name = 'PHP' THEN max_grade END) max_PHP,
       MAX(CASE WHEN skill_name = 'Laravel' THEN min_grade END) min_Laravel,
       MAX(CASE WHEN skill_name = 'Laravel' THEN max_grade END) max_Laravel,
       MAX(CASE WHEN skill_name = 'JavaScript' THEN min_grade END) min_JavaScript,
       MAX(CASE WHEN skill_name = 'JavaScript' THEN max_grade END) max_JavaScript,
       MAX(CASE WHEN skill_name = 'Angular' THEN min_grade END) min_Angular,
       MAX(CASE WHEN skill_name = 'Angular' THEN max_grade END) max_Angular,
       MAX(CASE WHEN skill_name = 'HTML' THEN min_grade END) min_HTML,
       MAX(CASE WHEN skill_name = 'HTML' THEN max_grade END) max_HTML
FROM criteria
JOIN user USING (user_id)
JOIN skill USING (skill_id)
GROUP BY user_id;

Records: 5  Duplicates: 0  Warnings: 0




user_name
min_PHP
max_PHP
min_Laravel
max_Laravel
min_JavaScript
max_JavaScript
min_Angular
max_Angular
min_HTML
max_HTML


John
1
1
1
5
4
5
4
5
1
5


SELECT user.user_name
FROM user_skill
JOIN user USING (user_id)
JOIN criteria USING (skill_id)
WHERE user_skill.grade BETWEEN criteria.min_grade AND criteria.max_grade
  AND user_skill.user_id <> criteria.user_id
GROUP BY user_skill.user_id
HAVING COUNT(*) = 5;


user_name


Jim