g1901_2000.s1934_confirmation_rate.script.sql Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of leetcode-in-kotlin Show documentation

Kotlin-based LeetCode algorithm problem solutions, regularly updated

There is a newer version: 1.28

# Write your MySQL query statement below
# #Medium #Database #2023_06_22_Time_1602_ms_(35.78%)_Space_0B_(100.00%)
select
  s.user_id
  , round(count(case when action = 'confirmed' then 1 end)
    / cast(count(*) as decimal(7,2)), 2) as confirmation_rate
  from
    Signups s
  left join
    Confirmations c
  on c.user_id = s.user_id
  group by 1