create table z (
A char(10)
);
 
insert into z
values ('##########');
 
create table s (
SNumber char(2) primary key,
Sname char(10),
Sstatus smallint,
City char(10)
);
 
insert into s
values ('S1', 'Smith', 20, 'London');
 
insert into s
values ('S2', 'Jones', 10, 'Paris');
 
insert into s
values ('S3', 'Blake', 30, 'Paris');
 
insert into s
values ('S4', 'Clark', 20, 'London');
 
insert into s
values ('S5', 'Adams', 30, 'Athens');
 
select *
from s;
 
select *
from z;
 
create table p (
PNumber char(2) primary key,
Pname char(10),
Color char(6),
Pweight smallint,
City char(10)
);
 
insert into p
values ('P1', 'Nut', 'Red', 12, 'London');
 
insert into p
values ('P2', 'Bolt', 'Green', 17, 'Paris');
 
insert into p
values ('P3', 'Screw', 'Blue', 17, 'Rome');
 
insert into p
values ('P4', 'Screw', 'Red', 12, 'Paris');
 
insert into p
values ('P5', 'Cam', 'Blue', 12, 'Paris');
 
insert into p
values ('P6', 'Cog', 'Red', 10, 'London');
 
select *
from p;
 
select *
from z;
 
create table sp(
SNumber char(2),
PNumber char(2),
Qty int,
primary key (SNumber, PNumber)
);
 
insert into sp
values ('S1', 'P1', 100);
 
insert into sp
values ('S1', 'P2', 200);
 
insert into sp
values ('S1', 'P3', 150);
 
insert into sp
values ('S1', 'P4', 400);
 
insert into sp
values ('S1', 'P5', 100);
 
insert into sp
values ('S1', 'P6', 300);
 
insert into sp
values ('S2', 'P1', 200);
 
insert into sp
values ('S2', 'P2', 100);
 
insert into sp
values ('S3', 'P2', 100);
 
insert into sp
values ('S4', 'P2', 400);
 
insert into sp
values ('S4', 'P4', 500);
 
insert into sp
values ('S4', 'P5', 200);
 
select *
from sp;
 
select *
from z;
 
select *
from s as sx, s as sy;
 
select s.Sname, s.Sname
from s as sx, s as sy
where sx.City = sy.City
 
select *
from z;
 
 

Y3JlYXRlIHRhYmxlIHogKApBIGNoYXIoMTApCik7CgppbnNlcnQgaW50byB6CnZhbHVlcyAoJyMjIyMjIyMjIyMnKTsKCmNyZWF0ZSB0YWJsZSBzICgKU051bWJlciBjaGFyKDIpIHByaW1hcnkga2V5LApTbmFtZSBjaGFyKDEwKSwKU3N0YXR1cyBzbWFsbGludCwKQ2l0eSBjaGFyKDEwKQopOwoKaW5zZXJ0IGludG8gcwp2YWx1ZXMgKCdTMScsICdTbWl0aCcsIDIwLCAnTG9uZG9uJyk7CgppbnNlcnQgaW50byBzCnZhbHVlcyAoJ1MyJywgJ0pvbmVzJywgMTAsICdQYXJpcycpOwoKaW5zZXJ0IGludG8gcwp2YWx1ZXMgKCdTMycsICdCbGFrZScsIDMwLCAnUGFyaXMnKTsKCmluc2VydCBpbnRvIHMKdmFsdWVzICgnUzQnLCAnQ2xhcmsnLCAyMCwgJ0xvbmRvbicpOwoKaW5zZXJ0IGludG8gcwp2YWx1ZXMgKCdTNScsICdBZGFtcycsIDMwLCAnQXRoZW5zJyk7CgpzZWxlY3QgKgpmcm9tIHM7CgpzZWxlY3QgKgpmcm9tIHo7CgpjcmVhdGUgdGFibGUgcCAoClBOdW1iZXIgY2hhcigyKSBwcmltYXJ5IGtleSwKUG5hbWUgY2hhcigxMCksCkNvbG9yIGNoYXIoNiksClB3ZWlnaHQgc21hbGxpbnQsCkNpdHkgY2hhcigxMCkKKTsKCmluc2VydCBpbnRvIHAKdmFsdWVzICgnUDEnLCAnTnV0JywgJ1JlZCcsIDEyLCAnTG9uZG9uJyk7CgppbnNlcnQgaW50byBwCnZhbHVlcyAoJ1AyJywgJ0JvbHQnLCAnR3JlZW4nLCAxNywgJ1BhcmlzJyk7CgppbnNlcnQgaW50byBwCnZhbHVlcyAoJ1AzJywgJ1NjcmV3JywgJ0JsdWUnLCAxNywgJ1JvbWUnKTsKCmluc2VydCBpbnRvIHAKdmFsdWVzICgnUDQnLCAnU2NyZXcnLCAnUmVkJywgMTIsICdQYXJpcycpOwoKaW5zZXJ0IGludG8gcAp2YWx1ZXMgKCdQNScsICdDYW0nLCAnQmx1ZScsIDEyLCAnUGFyaXMnKTsKCmluc2VydCBpbnRvIHAKdmFsdWVzICgnUDYnLCAnQ29nJywgJ1JlZCcsIDEwLCAnTG9uZG9uJyk7CgpzZWxlY3QgKgpmcm9tIHA7CgpzZWxlY3QgKgpmcm9tIHo7CgpjcmVhdGUgdGFibGUgc3AoClNOdW1iZXIgY2hhcigyKSwKUE51bWJlciBjaGFyKDIpLApRdHkgaW50LApwcmltYXJ5IGtleSAoU051bWJlciwgUE51bWJlcikKKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1MxJywgJ1AxJywgMTAwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1MxJywgJ1AyJywgMjAwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1MxJywgJ1AzJywgMTUwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1MxJywgJ1A0JywgNDAwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1MxJywgJ1A1JywgMTAwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1MxJywgJ1A2JywgMzAwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1MyJywgJ1AxJywgMjAwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1MyJywgJ1AyJywgMTAwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1MzJywgJ1AyJywgMTAwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1M0JywgJ1AyJywgNDAwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1M0JywgJ1A0JywgNTAwKTsKCmluc2VydCBpbnRvIHNwCnZhbHVlcyAoJ1M0JywgJ1A1JywgMjAwKTsKCnNlbGVjdCAqCmZyb20gc3A7CgpzZWxlY3QgKgpmcm9tIHo7CgpzZWxlY3QgKgpmcm9tIHMgYXMgc3gsIHMgYXMgc3k7CgpzZWxlY3Qgcy5TbmFtZSwgcy5TbmFtZQpmcm9tIHMgYXMgc3gsIHMgYXMgc3kKd2hlcmUgc3guQ2l0eSA9IHN5LkNpdHkKCnNlbGVjdCAqCmZyb20gejsKCg==