Update README.md

ieshreya · ieshreya · commit f51c125095c1 · 2024-03-30T00:21:11.000+05:30
diff --git a/README.md b/README.md
@@ -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;
 ```
