MySQL 学习笔记 发表于 2022-09-08 分类于 技术 Waline: 阅读次数: MySQL 基本用法和优化 查询 1234567SELECT customers.cust_name, customers.cust_id, COUNT(orders.order_num) AS num_ordFROM customers INNER JOIN ordersON customers.cust_id = orders.cust_idGROUP BY customers.cust_idORDER BY num_ord;