blob: aaceaca90df7a79582835a784c45fe5bb9ddf3a1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
SELECT
submission.id AS id,
user.username AS username,
submission.language AS language,
submission.details AS details,
submission.code AS code,
submission.code_length as code_length
FROM submission JOIN user
ON user.id = submission.user_id
WHERE submission.problem_id = ?1
ORDER BY submission.code_length;
|
