第四题的整个代码该如何实现

create table if not exists newfood(...);

insert into newfood

select * from food where foodPrice>=100 and foodPrice<=200;

# 赋值food表结构但是不复制数据
CREATE TABLE IF NOT EXISTS  new_food ( select * from food where 0 );
# 或者是
CREATE TABLE IF NOT EXISTS  new_food like food;
# insert into select 插入的数据从查询结果中获取
insert INTO new_food 
SELECT *  FROM food 
WHERE food_price 
BETWEEN 100  AND 200;