sql

CREATE DATABASE Baza4;
CREATE TABLE Partija
(
    PartijaID INT,
    TerenID INT,
    Datum DATE,
    VremePocetka TIME,
    VremeZavrsetka TIME,

    CONSTRAINT Partija_PK PRIMARY KEY(PartijaID)
);

INSERT INTO Partija VALUES (1, 1, '1/1/1978', '12:00', '13:00');
INSERT INTO Partija VALUES (2, 2, '2/17/1990', '12:00', '13:00');
INSERT INTO Partija VALUES (3, 3, '11/7/1991', '12:00', '13:00');
INSERT INTO Partija VALUES (4, 4, '5/31/1980', '12:00', '13:00');
INSERT INTO Partija VALUES (5, 5, '9/12/1993', '12:00', '13:00');
INSERT INTO Partija VALUES (6, 6, '6/30/1991', '12:00', '13:00');
INSERT INTO Partija VALUES (7, 7, '8/11/1984', '12:00', '13:00');
INSERT INTO Partija VALUES (8, 8, '5/22/1983', '12:00', '13:00');
INSERT INTO Partija VALUES (9, 9, '12/15/1981', '12:00', '13:00');
INSERT INTO Partija VALUES (10, 10, '8/8/1970', '12:00', NULL);
INSERT INTO Partija VALUES (11, 11, '8/8/1970', '12:00', NULL);
INSERT INTO Partija VALUES (12, 12, '8/8/1970', '12:00', NULL);
INSERT INTO Partija VALUES (13, 13, '8/8/1970', '12:00', NULL);
INSERT INTO Partija VALUES (14, 14, '8/8/1970', '12:00', NULL);
INSERT INTO Partija VALUES (15, 15, '8/8/1970', '12:00', NULL);

SELECT PartijaID,VremePocetka,Datum FROM Partija WHERE VremeZavrsetka IS NULL ORDER BY Datum DESC;