sql

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.2000','7:00:00 AM','8:00:00 AM');
INSERT INTO Partija VALUES (2,2,'10.1.2001','8:00:00 AM','12:00:00 AM');
INSERT INTO Partija VALUES (3,3,'12.1.2000','9:00:00 AM','11:00:00 AM');
INSERT INTO Partija VALUES (4,4,'1.1.2005','10:00:00 AM','10:00:00 AM');
INSERT INTO Partija VALUES (5,5,'1.1.2006','11:00:00 AM','8:00:00 AM');
INSERT INTO Partija VALUES (6,6,'12.10.2000','12:00:00 AM','9:00:00 AM');
INSERT INTO Partija VALUES (7,7,'12.10.2010','12:00:00 AM','9:00:00 AM');
INSERT INTO Partija VALUES (8,8,'14.12.2005','12:00:00 AM','9:00:00 AM');
INSERT INTO Partija VALUES (9,9,'9.10.2017','12:00:00 AM','9:00:00 AM');

SELECT TerenID,Datum FROM Partija;
SELECT PartijaID,VremePocetka,Datum FROM Partija ORDER BY Datum DESC;