New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[3차] 주간 가장 많이 풀이된 문제 조회 API 구현 #426

Open

hun-ca opened this issue Sep 27, 2024 · 1 comment

Assignees

Labels

feature

Member

hun-ca commented Sep 27, 2024

샘플 쿼리

select t1.problem_id
from (
    SELECT problem_id, COUNT(*) AS submit_count
    FROM SUBMIT_HISTORY
    WHERE created_at >= NOW() - INTERVAL 7 DAY
    GROUP BY problem_id
) t1
order by t1.submit_count desc
limit 1;

hun-ca added the feature label

hun-ca self-assigned this

Member Author

hun-ca commented Oct 16, 2024

�기획 이슈로 딜레이

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment