Question

i need solutions for this.

Answer 1

mysql>create table item(itemcode int,itemname varchar(15),price float,qsold int);

mysql>insert into item values (1001,'cake',100,150);

.......insert 10 values like this

now let us answer 5 questions

1) select itemname,qsold from item;

2) select * from item where qsold>100;

3) select * from item where qsold<10;

4) select * from item where qsold>50 or price<500;

5) select * from item where itemcode=1001;