select count(all grade) from customer;
SELECT COUNT(DISTINCT customer_id) FROM customer WHERE grade IS NOT NULL;
select count(all grade) from customer;
SELECT COUNT(DISTINCT customer_id) FROM customer WHERE grade IS NOT NULL;
转载于:https://www.cnblogs.com/books2read/p/11174591.html