[2480#_EASY] Form a Chemical Bond
·
SQL/LeetCode
보호되어 있는 글입니다.
[2377#_EASY] Sort the Olympic Table
·
SQL/LeetCode
보호되어 있는 글입니다.
[1076#_EASY] Project Employees II
·
SQL/LeetCode
보호되어 있는 글입니다.
[1075#_EASY] Project Employees I
·
SQL/LeetCode
보호되어 있는 글입니다.
[1141_EASY] User Activity for the Past 30 Days I
·
SQL/LeetCode
Table: Activity +---------------+---------+ | Column Name | Type | +---------------+---------+ | user_id | int | | session_id | int | | activity_date | date | | activity_type | enum | +---------------+---------+ There is no primary key for this table, it may have duplicate rows. The activity_type column is an ENUM of type ('open_session', 'end_session', 'scroll_down', 'send_message'). The table ..
[603#_EASY]Consecutive Available Seats
·
SQL/LeetCode
보호되어 있는 글입니다.
[597_EASY] Friend Requests I : Overall Acceptance Rate
·
SQL/LeetCode
Problem Description – Write an SQL query to find the overall acceptance rate of requests, which is the number of acceptance divided by the number of requests. Return the answer rounded to 2 decimals places. Note That – The accepted requests are not necessarily from the table friend_request. In this case, Count the total accepted requests (no matter whether they are in the original requests), and..
[596_EASY] Classes More Than 5 Students
·
SQL/LeetCode
Table: Courses +-------------+---------+ | Column Name | Type | +-------------+---------+ | student | varchar | | class | varchar | +-------------+---------+ (student, class) is the primary key column for this table. Each row of this table indicates the name of a student and the class in which they are enrolled. Write an SQL query to report all the classes that have at least five students. Retur..