Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.27 KB | None | 0 0
  1. SELECT H.hacker_id, H.name, S.submission_id FROM Hackers AS H
  2. INNER JOIN Submissions AS S ON H.hacker_id = S.hacker_id
  3. INNER JOIN Challenges AS C ON S.challenge_id = C.challenge_id
  4. INNER JOIN Difficulty AS D ON C.difficulty_level = D.difficulty_level
  5. WHERE S.score = D.score
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement