leetcode

Solution to some Leetcode problems written in C++

git clone git://git.dimitrijedobrota.com/leetcode.git

1934.sql (183B)

1 SELECT S.user_id, 2 ROUND(AVG(if(C.action="confirmed", 1, 0)), 2) AS confirmation_rate 3 FROM Signups AS S 4 LEFT JOIN Confirmations AS C 5 ON S.user_id = C.user_id 6 GROUP BY user_id;