INSERT INTO item (iname,itype)
VALUES ('cappuccino','hot drink'),
       ('macchiato','hot drink'),
       ('orange juice','cold drink');

INSERT INTO Cafe (license,cname,address)
VALUES ('12345','abc','1 palm street'),
       ('22346','cba','2 canal road'),
       ('65432','aaa','3 hill drive');

INSERT INTO Client (cid,name,phone)
VALUES ('1','hadas','111111'),
       ('2','danny','222222'),
       ('3','yossi','444444');

INSERT INTO Sells (license,iname,price)
VALUES ('12345','cappuccino','5.5'),
       ('12345','orange juice','7'),
       ('22346','macchiato','8'),
       ('22346','orange juice','4.5'),
       ('65432','cappuccino','10');

INSERT INTO Receipt(cid,rno,license,rdate)
VALUES ('1','1','12345','1/7/2017'),
       ('2','1','22346','8/7/2017'),
       ('3','1','65432','20/7/2017'),
       ('1','2','12345','22/7/2017');

INSERT INTO Buys (cid,rno,iname,amount)
VALUES ('1','1','cappuccino','2'),
       ('2','1','macchiato','2'),
       ('3','1','orange juice','3'),
       ('1','2','cappuccino','2'),
       ('1','2','orange juice','1');