search

1321. Restaurant Growth

https://leetcode.com/problems/restaurant-growth

hashtag
Description

Table: Customer


+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| customer\_id   | int     |
| name          | varchar |
| visited\_on    | date    |
| amount        | int     |
+---------------+---------+
(customer\_id, visited\_on) is the primary key for this table.
This table contains data about customer transactions in a restaurant.
visited\_on is the date on which the customer with ID (customer\_id) have visited the restaurant.
amount is the total paid by a customer.

You are the restaurant owner and you want to analyze a possible expansion (there will be at least one customer every day).

Write an SQL query to compute moving average of how much customer paid in a 7 days window (current day + 6 days before) .

The query result format is in the following example:

Return result table ordered by visited_on.

average_amountshould be rounded to 2 decimal places, all dates are in the format ('YYYY-MM-DD').

hashtag
ac

Previous1320. Minimum Distance to Type a Word Using Two FingersNext1322. Ads Performance

Last updated