调试中...
调试中...
题目描述
题目描述
题解
题解
提交记录
提交记录
代码
代码
测试用例
测试用例
测试结果
测试结果
行 1，列 1
运行和提交代码需要登录
Members =
| member_id | name | | --------- | ------- | | 9 | Alice | | 11 | Bob | | 3 | Winston | | 8 | Hercy | | 1 | Narihan |
Visits =
| visit_id | member_id | visit_date | | -------- | --------- | ---------- | | 22 | 11 | 2021-10-28 | | 16 | 11 | 2021-01-12 | | 18 | 9 | 2021-12-10 | | 19 | 3 | 2021-10-19 | | 12 | 11 | 2021-03-01 | | 17 | 8 | 2021-05-07 | | 21 | 9 | 2021-05-12 |
Purchases =
| visit_id | charged_amount | | -------- | -------------- | | 12 | 2000 | | 18 | 9000 | | 17 | 7000 |