order-by | brain

Practice › LeetCode › LeetCode (archived) › LeetCode 06xx ›

LeetCode 620: Not Boring Movies

Problem Restatement We are given a table Cinema . Each row represents a movie. Column Type Meaning id int Movie id movie varchar Movie name description varchar Movie description rating float Movie rating We need to: Select movies with odd id values Exclude movies whose description is "boring" Sort the result by rating in descending order The official problem asks for filtering movies with odd IDs and non-boring descriptions, ordered...

Practice › LeetCode › LeetCode (archived) › LeetCode 05xx ›

LeetCode 586: Customer Placing the Largest Number of Orders

Problem Restatement We are given an Orders table. Each row represents one order and the customer who placed it. We need to return the customer_number of the customer who placed the largest number of orders. The test cases guarantee that exactly one customer has more orders than every other customer. The table has order_number as the primary key and customer_number as the customer ID. Table Orders Column Type Meaning order_number...

Practice › LeetCode › LeetCode (archived) › LeetCode 05xx ›

LeetCode 578: Get Highest Answer Rate Question

Problem Restatement We are given a table called SurveyLog . Each row records one user action on one question. The action can be: 'show' 'answer' 'skip' The answer rate of a question is: number of answer actions / number of show actions We need to return the question_id with the highest answer rate. If multiple questions have the same highest answer rate, return the smallest question_id . The returned column...

#order-by

LeetCode 620: Not Boring Movies

LeetCode 586: Customer Placing the Largest Number of Orders

LeetCode 578: Get Highest Answer Rate Question