NC222730. SQL测试

描述

示例1

输入:

drop table if exists product;
create table product
(
id int,
prodname varchar(255),
score int,
supplier varchar(255)
);
insert into product values (1, 'disk', 86, 'IBM');
insert into product values (2, 'tape', 55, 'IBM');
insert into product values (3, 'RAM', 90, 'IBM');
insert into product values (4, 'CPU', 100, 'Intel');
insert into product values (5, 'cache', '88', 'Intel');

输出:

83.8000

原站题解