在orders資料表查出CustomerID是apple的訂單資訊有幾筆。 select count( * ) as 訂單數from orders where customerID = (select id from Customers where name = 'apple').
確定! 回上一頁