Leetcode Problem 578. Get Highest Answer Rate Question

578. Get Highest Answer Rate Question

Leetcode Solutions

Calculating Answer Rate and Ordering Results

Group the records by question_id to calculate metrics per question.
Count the number of times each question was answered using COUNT(answer_id).
Count the number of times each question was shown using COUNT(CASE WHEN action = 'show' THEN 1 ELSE NULL END).
Calculate the answer rate by dividing the count of answers by the count of shows.
Order the results by answer rate in descending order to get the highest rate first.
For questions with the same answer rate, order by question_id in ascending order to get the smallest question_id.
Limit the results to 1 row to get the question with the highest answer rate.


erDiagram
    SurveyLog {
        int id
        ENUM action
        int question_id
        int answer_id
        int q_num
        int timestamp
    }

Using Average of Indicators to Calculate Answer Rate

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 578. Get Highest Answer Rate Question

Leetcode Solutions

Calculating Answer Rate and Ordering Results

Solution Idea

Query Steps

Code Implementation

Using Average of Indicators to Calculate Answer Rate

Ask Question

Suggested Answer