CREATE TABLE osobe (jmbg STRING, ime STRING, tezina INTEGER,
	zaposlen BOOL, visina FLOAT, spol CHAR);

INSERT INTO TABLE osobe VALUES ('1111', 'Pero', 77, false, 1.81, m);
INSERT INTO TABLE osobe VALUES ('2222', 'Ana', 49, , 1.59, 'f');
INSERT INTO TABLE osobe VALUES ('3333', 'Iva', 102, false, , 'f');
INSERT INTO TABLE osobe VALUES ('4444', 'Pero', , true, 1.87, 'm');
INSERT INTO TABLE osobe VALUES ('5555', 'Iva', 67, , 1.67, 'f');
INSERT INTO TABLE osobe VALUES ('6666', 'Pero', 99, true, 1.92, 'm');

SELECT * FROM osobe; SELECT ime, tezina FROM osobe;
SELECT MAX(tezina) FROM osobe;
SELECT MIN(tezina), SUM(visina) FROM osobe;
SELECT ime, COUNT(jmbg) FROM osobe GROUP BY ime;
SELECT ime, SUM(tezina) FROM osobe GROUP BY ime HAVING SUM(tezina) > 100;
SELECT spol, zaposlen, COUNT(jmbg), MAX(visina) FROM osobe GROUP BY spol, zaposlen;

DROP TABLE osobe;
DROP TABLE vozila;