‐‐ 准备数据2 create table car3 id int4 color char25 price float6 ;78 insert into caridcolorprice values1黄色16;9 insert into caridcolorprice values2黄色16;10 insert into caridcolorprice values3蓝色5;11 insert i

-- 查询黄色车的数量和总价 SELECT COUNT(*) AS "黄色车数量", SUM(price) AS "黄色车总价" FROM car WHERE color = '黄色';

-- 查询每种颜色车的数量和平均价 SELECT color, COUNT(*) AS "车数量", AVG(price) AS "平均价" FROM car GROUP BY color;

-- 查询价格最高的车的颜色和价格 SELECT color, price AS "最高价格" FROM car ORDER BY price DESC LIMIT 1;

-- 查询价格排名前三的车的颜色和价格 SELECT color, price AS "价格" FROM car ORDER BY price DESC LIMIT 3;

-- 查询价格高于平均价的车的数量和平均价格 SELECT COUNT(*) AS "高于平均价的车数量", AVG(price) AS "平均价格" FROM car WHERE price > (SELECT AVG(price) FROM car);