create table items ( id int not null primary key, name varchar(100), price int, category varchar(100) ); insert into items values(1, 'りんご', 190, 'くだもの'); insert into items values(2, 'みかん', 100, 'くだもの'); insert into items values(3, 'きゅうり', 80, '野菜'); insert into items values(4, '人参', 110, '野菜'); insert into items values(5, 'キャベツ', 110, '野菜'); insert into items values(6, '豚肉', 300, '肉'); insert into
