New MySQL CODES

create table item(I_ID char(30),ItemName char(60),Manufacturer char(6), Price int);
desc item;
insert into item values("PC01","Personal Computer","ABC",35000);
insert into item values("LC05","Laptop","ABC",55000);
insert into item values("PC03","Personal Computer","XYZ",32000);
insert into item values("PC06","Personal Computer","COMP",37000);
insert into item values("LC03","Laptop","PQR",57000);
SELECT* from item;
create table customer(C_ID int, CustomerName char(50), City char(10),I_ID char(10));
desc customer;
insert into customer values(01,"N Roy","Delhi","LC03");
insert into customer values(06,"H Singh","Mumbai","PC03");
insert into customer values(12,"R Pandey","Delhi","PC06");
insert into customer values(15,"C Sharma","Delhi","LC03");
insert into customer values(16,"K Agarwal","Banglore","PC01");
select* from customer;
SELECT* FROM item WHERE price BETWEEN 35000 AND 55000;
SELECT* FROM item WHERE price > 35000 AND price < 55000;
SELECT
Customer.CustomerName,
Customer.City,
Item.ItemName,
Item.Price,
Customer.I_ID
FROM
Customer
JOIN
Item ON Customer.I_ID = Item.I_ID;