Atharv625
diff --git a/‎README.md
Lines changed: 14 additions & 0 deletions b/‎README.md
Lines changed: 14 additions & 0 deletions
@@ -592,4 +592,18 @@ GROUP BY title
 ORDER BY AVG(rating) DESC, title ASC
 LIMIT 1 
 )
+```
+
+[1321. Restaurant Growth](https://leetcode.com/problems/restaurant-growth/)
+```sql
+-- pay: last 7 days (today inclusive) - avg.amt (round, 2)
+
+SELECT visited_on, amount, ROUND(amount/7, 2) AS average_amount
+FROM (
+    SELECT DISTINCT visited_on,
+    SUM(amount) OVER(ORDER BY visited_on RANGE BETWEEN INTERVAL 6 DAY PRECEDING AND CURRENT ROW) AS amount,
+    MIN(visited_on) OVER() day_1
+    FROM Customer
+) t
+WHERE visited_on >= day_1+6;
 ```