@milan123

-- create a table CREATE TABLE KOMINTENTI( KOMINTENT_id INTEGER PRIMARY KEY, NAZIV VARCHAR(20) NOT NULL, GRAD VARCHAR(20) NOT NULL, STATUS VARCHAR(10) NOT NULL ); -- insert some values INSERT INTO KOMINTENTI VALUES (1, 'MURAJ D.O.O.', 'ZADAR','DOBAVLJAC'); INSERT INTO KOMINTENTI VALUES (2, 'MURAJ D.O.O.', 'ZADAR','KUPAC');

-- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL ); -- insert some values INSERT INTO students VALUES (1, 'Ryan', 'M'); INSERT INTO students VALUES (2, 'Joanna', 'F'); -- fetch some values