leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE

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;