hijoshoku.sql

---

drop table hijoshoku; create table hijoshoku( hname text, hgenre text, hcost int8, hweigh int8 ); Insert into hijoshoku(hname,hgenre,hcost,hweigh) values('A','sweet',2000,300); Insert into hijoshoku(hname,hgenre,hcost,hweigh) values('B','rice',1500,180); Insert into hijoshoku(hname,hgenre,hcost,hweigh) values('C','pan',700,150); Insert into hijoshoku(hname,hgenre,hcost,hweigh) values('G','sweet',850,200); Insert into hijoshoku(hname,hgenre,hcost,hweigh) values('H','water',1000,210); Insert into hijoshoku(hname,hgenre,hcost,hweigh) values('I','noodle',1500,160);