调试中...
调试中...
题目描述
题目描述
题解
题解
提交记录
提交记录
代码
代码
测试用例
测试用例
测试结果
测试结果
行 1,列 1
运行和提交代码需要登录
Customers =
| customer_id | name | country | | ----------- | -------- | ------- | | 1 | Winston | USA | | 2 | Jonathan | Peru | | 3 | Moustafa | Egypt |
Product =
| product_id | description | price | | ---------- | ----------- | ----- | | 10 | LC Phone | 300 | | 20 | LC T-Shirt | 10 | | 30 | LC Book | 45 | | 40 | LC Keychain | 2 |
Orders =
| order_id | customer_id | product_id | order_date | quantity | | -------- | ----------- | ---------- | ---------- | -------- | | 1 | 1 | 10 | 2020-06-10 | 1 | | 2 | 1 | 20 | 2020-07-01 | 1 | | 3 | 1 | 30 | 2020-07-08 | 2 | | 4 | 2 | 10 | 2020-06-15 | 2 | | 5 | 2 | 40 | 2020-07-01 | 10 | | 6 | 3 | 20 | 2020-06-24 | 2 | | 7 | 3 | 30 | 2020-06-25 | 2 | | 9 | 3 | 30 | 2020-05-08 | 3 |