首页 > 试题广场 >

假设有以下数据表"orders"（order_id为主键），

[不定项选择题]

假设有以下数据表"orders"（order_id为主键），记录了订单的信息：

order_id	customer_id	order_date	amount
1	1001	2022-01-01	100
2	1002	2022-01-02	150
3	1001	2022-01-03	200
4	1003	2022-01-04	120

请选出查询语句，找出每个顾客的订单数量，以及该顾客的第一笔订单的日期（）

SELECT customer_id, COUNT(order_id) as order_count, MIN(order_date) as first_order_date FROM orders GROUP BY customer_id;

SELECT customer_id, COUNT(*) as order_count, MIN(order_date) as first_order_date FROM orders GROUP BY customer_id;

ELECT customer_id, COUNT(order_id) as order_count, order_date as first_order_date FROM orders GROUP BY customer_id ORDER BY order_date ASC;

SELECT customer_id, COUNT(order_id) as order_count, MAX(order_date) as first_order_date FROM orders GROUP BY customer_id;

查看正确选项

这道题你会答吗？花几分钟告诉大家答案吧！

提交观点

问题信息

来自：2024秋招-字节跳动...

难度：

0条回答 3收藏 73浏览

扫一扫，把题目装进口袋