pzNYAcPJ

1DROP TABLE IF EXISTS telefonok;
2DROP TABLE IF EXISTS diakok;
3CREATE TABLE telefonok
4(
5	id INTEGER PRIMARY KEY,
6	gyarto VARCHAR(30) NOT NULL,
7	tipus VARCHAR(30) NOT NULL,
8	oprendszer VARCHAR(30) NOT NULL,
9	ar INTEGER NOT NULL
10);
11INSERT INTO telefonok VALUES('1000','SAMSUNG','GALAXY S9','ANDROID',190000);
12INSERT INTO telefonok VALUES('1001','SAMSUNG','GALAXY S8','ANDROID',120000);
13INSERT INTO telefonok VALUES('1002','SAMSUNG','GALAXY S7','ANDROID',90000);
14INSERT INTO telefonok VALUES('1003','SAMSUNG','GALAXY S6','ANDROID',50000);
15INSERT INTO telefonok VALUES('1004','SAMSUNG','GALAXY S3','ANDROID',20000);
16INSERT INTO telefonok VALUES('1005','APPLE','5','IOS',40000);
17INSERT INTO telefonok VALUES('1006','APPLE','7','IOS',120000);
18INSERT INTO telefonok VALUES('1007','APPLE','X','IOS',210000);
19INSERT INTO telefonok VALUES('1008','APPLE','5S','IOS',50000);
20INSERT INTO telefonok VALUES('1009','APPLE','6','IOS',90000);