结果1:SELECT vend_id,prod_id,prod_price FROM products WHERE prod_price<=5结果2:SELECT vend_id,prod_id,prod_price FROM products WHERE vend_id IN(1001,1002)合并两个结果集:SELECT&nbs
现在有张表products是产品表,vend_id是供应商id,prod_price是供应价格,现在需要统计每个供应商供应了多少商品,供应商品的平均价格,sql如下:SELECT
vend_id,
AVG( prod_price ),
COUNT( * ) AS num_prods
FROM
products
GROUP BY
vend_id输出结果如下:vend_id &nbs
从产品表中统计表中的:记录条数,最小价格,最大价格,平均值SELECT
COUNT(*) AS num_items,
MIN(prod_price) AS price_min,
MAX(prod_price) AS price_max,
AVG(prod_price) AS price_avg
FROM
products