leetcode

Solution to some Leetcode problems written in C++

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

1321.sql (411B)

0 SELECT a.visited_on, 1 SUM(b.day_sum) AS amount, 2 ROUND(AVG(b.day_sum), 2) AS average_amount 3 FROM 4 (SELECT visited_on, SUM(amount) AS day_sum FROM Customer GROUP BY visited_on ) a, 5 (SELECT visited_on, SUM(amount) AS day_sum FROM Customer GROUP BY visited_on ) b 6 WHERE DATEDIFF(a.visited_on, b.visited_on) BETWEEN 0 AND 6 7 GROUP BY a.visited_on 8 HAVING COUNT(b.visited_on) = 7 9 ORDER BY visited_on