Problem

1
2
3
4
5
6
7

+-------------+------+
| Column Name | Type |
+-------------+------+
| problem_id  | int  |
| likes       | int  |
| dislikes    | int  |
+-------------+------+

problem_id is the primary key column for this table. Each row of this table indicates the number of likes and dislikes for a Leetcode problem.

Write an SQL query to report the IDs of the low-quality problems. A Leetcode problem is low-quality if the like percentage of the problem (number of likes divided by the total number of votes) is strictly less than 60%.

Return the result table ordered by problem_id in ascending order.

Solution

Method 1 - Using Division

Code

1
2
3
4

SELECT problem_id
FROM Problems
WHERE (likes / (likes + dislikes)) < .6
ORDER BY problem_id;