题目链接:点击打开链接
题目大意:略。
解题思路:略。
AC 代码
SELECT DATE_FORMAT(order_date, '%Y-%m') month, COUNT(*) order_count, COUNT(DISTINCT customer_id) customer_count FROM Orders WHERE invoice > 20 GROUP BY month
题目链接:点击打开链接
题目大意:略。
解题思路:略。
AC 代码
SELECT DATE_FORMAT(order_date, '%Y-%m') month, COUNT(*) order_count, COUNT(DISTINCT customer_id) customer_count FROM Orders WHERE invoice > 20 GROUP BY month