SQL测试
题号:NC222730
时间限制:C/C++/Rust/Pascal 1秒,其他语言2秒
空间限制:C/C++/Rust/Pascal 256 M,其他语言512 M
64bit IO Format: %lld

题目描述

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