c**z
发帖数: 669 | 1 If you know SQL, please, as simply as possible, design a single table to
hold orders made by customers. You may assume details (including names)
about customers are held in some other table. Using the table that you
designed for orders, and this other table, present a single query that gives
the number of orders for every customer, one line per customer. | b********n
发帖数: 5997 | | l*****y
发帖数: 33 | 3 Is this an interview Question?
Select O.customer_ID, Count(*) as TotalNumberofOrdersForEachCustomer
From Orders O
Group by O.customer_ID |
|
