Leetcode Problem 1211. Queries Quality and Percentage

1211. Queries Quality and Percentage

Leetcode Solutions

Select the query_name column to group the results by each query.
Calculate the quality by averaging the ratio of rating to position for each query.
Calculate the poor_query_percentage by summing the instances where rating is less than 3, dividing by the total count of queries for each query_name, and multiplying by 100 to get the percentage.
Use the ROUND() function to format both quality and poor_query_percentage to two decimal places.
Group the results by query_name using the GROUP BY clause.


erDiagram
    Queries {
        varchar query_name
        varchar result
        int position
        int rating
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen