create table customer1(
customerid int primary key,
customername varchar(20),
contactno int,
adddress varchar(20),
postcode int,city varchar(20),
country varchar(20));
create table employees1(
empid int primary key,
firstname varchar(20),
lastname varchar(20),
birthdate date
);
CREATE table orders1(
orderid int primary key,
customerid int,empid int,
orderdate date,shipperid int,
foreign key(customerid) references customer1(customerid),
foreign key(empid) references employees1(empid));



insert into customer1 values(1,'reenu',12345,'kottayam',9757,'peru','india');
insert into customer1 values(8,'nikhitha',8789996,'india',9728,'africa','canada');
insert into customer1 values(6,'tiya',67583875,'L',9757,'PERA','america');
insert into customer1 values(4,'rose',54322934,'dcs',9657,'amb','germany');
insert into customer1 values(5,'maria',128374,'mumabi',6757,'pertu','india');
insert into employees1(empid,firstname,lastname,birthdate)  values(6,'reenu','johny','10/02/2000');
insert into employees1(empid,firstname,lastname,birthdate)  values(7,'tiya','biju','16/09/2001');
insert into employees1(empid,firstname,lastname,birthdate)  values(8,'rose','jo','7/02/2002');
insert into employees1(empid,firstname,lastname,birthdate)  values(9,'fida','naar','15/01/2003');
insert into employees1(empid,firstname,lastname,birthdate)  values(10,'hridhya','balan','12/02/2004');
insert into orders1 values(11,2,7,'12/4/2023',23);
insert into orders1 values(12,1,6,'17/4/2023',33);
insert into orders1 values(13,4,9,'14/4/2023',53);
insert into orders1 values(14,5,10,'19/4/2023',63);
insert into orders1 values(15,3,8,'22/4/2023',83);



select * from customer1 order by customername asc;