It seems like you're asking for a SQL query to solve this problem. Here's a step-by-step solution:

1. First, we need to join the tables. We'll join the `Submissions` table with the `Challenges` table on `challenge_id`, and then join this with the `Difficulty` table on `difficulty_level`. This will give us a table that includes each submission, the challenge it belongs to, and the maximum score for that challenge's difficulty level.

2. Next, we'll filter this table to only include submissions where the score is equal to the maximum score for that challenge's difficulty level. This will give us a table of all the submissions where the hacker achieved a full score.

3. Then, we'll group this table by `hacker_id` and count the number of full score submissions for each hacker.

4. Finally, we'll filter this table to only include hackers who achieved full scores for more than one challenge, and order the results as specified.

Here's what the SQL query might look like:

```sql
SELECT h.hacker_id, h.name
FROM Hackers h
JOIN (
SELECT s.hacker_id, COUNT(*) as full_score_count
FROM Submissions s
JOIN Challenges c ON s.challenge_id = c.challenge_id
JOIN Difficulty d ON c.difficulty_level = d.difficulty_level
WHERE s.score = d.score
GROUP BY s.hacker_id
HAVING COUNT(*) 1
) fs ON h.hacker_id = fs.hacker_id
ORDER BY fs.full_score_count DESC, h.hacker_id ASC;
```

This query first creates a subquery (`fs`) that counts the number of full score submissions for each hacker, and then joins this with the `Hackers` table to get the hacker names. The `HAVING` clause in the subquery is used to only include hackers with more than one full score submission. The final results are ordered by the number of full score submissions in descending order, and then by `hacker_id` in ascending order.

Question

It seems like you're asking for a SQL query to solve this problem. Here's a step-by-step solution:

1. First, we need to join the tables. We'll join the `Submissions` table with the `Challenges` table on `challenge_id`, and then join this with the `Difficulty` table on `difficulty_level`. This will give us a table that includes each submission, the challenge it belongs to, and the maximum score for that challenge's difficulty level.

2. Next, we'll filter this table to only include submissions where the score is equal to the maximum score for that challenge's difficulty level. This will give us a table of all the submissions where the hacker achieved a full score.

3. Then, we'll group this table by `hacker_id` and count the number of full score submissions for each hacker.

4. Finally, we'll filter this table to only include hackers who achieved full scores for more than one challenge, and order the results as specified.

Here's what the SQL query might look like:

```sql
SELECT h.hacker_id, h.name
FROM Hackers h
JOIN (
    SELECT s.hacker_id, COUNT(*) as full_score_count
    FROM Submissions s
    JOIN Challenges c ON s.challenge_id = c.challenge_id
    JOIN Difficulty d ON c.difficulty_level = d.difficulty_level
    WHERE s.score = d.score
    GROUP BY s.hacker_id
    HAVING COUNT(*) > 1
) fs ON h.hacker_id = fs.hacker_id
ORDER BY fs.full_score_count DESC, h.hacker_id ASC;
```

This query first creates a subquery (`fs`) that counts the number of full score submissions for each hacker, and then joins this with the `Hackers` table to get the hacker names. The `HAVING` clause in the subquery is used to only include hackers with more than one full score submission. The final results are ordered by the number of full score submissions in descending order, and then by `hacker_id` in ascending order.

Knowee AI · Accepted Answer

It seems like you're asking for a SQL query to solve this problem. Here's a step-by-step solution:

1. First, we need to join the tables. We'll join the `Submissions` table with the `Challenges` table on `challenge_id`, and then join this with the `Difficulty` table on `difficulty_level`. This will give us a table that includes each submission, the challenge it belongs to, and the maximum score for that challenge's difficulty level.

2. Next, we'll filter this table to only include submissions where the score is equal to the maximum score for that challenge's difficulty level. This will give us a table of all the submissions where the hacker achieved a full score.

3. Then, we'll group this table by `hacker_id` and count the number of full score submissions for each hacker.

4. Finally, we'll filter this table to only include hackers who achieved full scores for more than one challenge, and order the results as specified.

Here's what the SQL query might look like:

```sql
SELECT h.hacker_id, h.name
FROM Hackers h
JOIN (
    SELECT s.hacker_id, COUNT(*) as full_score_count
    FROM Submissions s
    JOIN Challenges c ON s.challenge_id = c.challenge_id
    JOIN Difficulty d ON c.difficulty_level = d.difficulty_level
    WHERE s.score = d.score
    GROUP BY s.hacker_id
    HAVING COUNT(*) > 1
) fs ON h.hacker_id = fs.hacker_id
ORDER BY fs.full_score_count DESC, h.hacker_id ASC;
```

This query first creates a subquery (`fs`) that counts the number of full score submissions for each hacker, and then joins this with the `Hackers` table to get the hacker names. The `HAVING` clause in the subquery is used to only include hackers with more than one full score submission. The final results are ordered by the number of full score submissions in descending order, and then by `hacker_id` in ascending order.

Question

Solution

Similar Questions

Upgrade your grade with Knowee