1934. Confirmation Rate | SQL 50 | Leetcode | SQL Interview | Multiple CTEs in a single query

preview_player
Показать описание
The confirmation rate of a user is the number of 'confirmed' messages divided by the total number of requested confirmation messages. The confirmation rate of a user that did not request any confirmation messages is 0. Round the confirmation rate to two decimal places.

Write a solution to find the confirmation rate of each user.

Return the result table in any order.
Рекомендации по теме
Комментарии
Автор

Mam you need to explain why we are doing this step, otherwise how we understand

ketanthakkar
welcome to shbcf.ru