MYSQL必知必会第13章SQL语句

SELECT vend_id,COUNT(*) AS num_prods FROM products GROUP BY vend_id HAVING COUNT(num_prods) >= 3;

SELECT cust_id ,COUNT(*) AS orders FROM orders GROUP BY cust_id HAVING COUNT(*) >=2;

SELECT vend_id , COUNT(*) as num_prods FROM products WHERE prod_price >=5 GROUP BY vend_id HAVING COUNT(num_prods) >= 2;

SELECT vend_id,COUNT(*) AS num_prods FROM products;

SELECT order_num,SUM(quantity*item_price) AS sum_price FROM orderitems GROUP BY order_num HAVING sum_price >= 50 ORDER BY sum_price DESC;