create table Dijak(
ID_Dijak int primary key ,
Ime varchar(30),
Priimek varchar(30),
Starost number,
Razred varchar(30),
Uspeh varchar(30));

Insert into Dijak(1,'Janez','Novak',18,'3.Ra','PravDober');
Insert into Dijak(2,'Jure','Jurčič',19,'2.Ra','Zadosten');
Insert into Dijak(3,'Miha','Mihelčič',20,'4.Ra','Odličen');

SELECT Ime,Priimek FROM Dijak;

SELECT Ime FROM Dijak
WHERE Ime like 'J%' or 'M%';

SELECT Ime FROM Dijak
WHERE Ime like 'J%' AND Ime like 'M%';

SELECT Ime FROM Dijak
WHERE Ime like '%e_';

SELECT Ime FROM Dijak
WHERE Ime like 'J%' AND Ime like '__n%';

SELECT Ime FROM Dijak
WHERE Ime like 'J%' OR Ime like '__n%';

SELECT Ime,Razred FROM Dijak
WHERE Ime like '__r%';

UPDATE Dijak SET Starost=Starost+1;

UPDATE Dijak SET Starost=20
WHERE Ime='Janez';

UPDATE Dijak SET Razred=4.Ra Uspeh=dober
WHERE Ime='Janez';

INSERT INTO DijakiKopija SELECT * FROM Dijak;

DELETE FROM Dijak
WHERE Ime='Miha';

SELECT DISTINCT Ime FROM Dijak;

SELECT Ime,Priimek FROM Dijak
WHERE Starost<18;

SELECT Ime,Priimek FROM Dijak
WHERE Starost BETTWEEN 15 AND 20;

SELECT Ime,Starost FROM Dijak
WHERE Starost BETTWEEN 15 AND 20;

SELECT Ime,Starost FROM Dijak
ORDER BY Starost ASC;

SELECT Ime,Starost FROM Dijak
ORDER BY Starost DESC;

SELECT Ime,Priimek FROM Dijak
ORDER BY Ime DESC AND Priimek DESC;

SELECT Ime,Priimek FROM Dijak
ORDER BY Ime DESC AND Priimek ASC;

DELETE FROM DijakiKopija;

TRUNCATE TABLE DijakiKopija;

DROP TABLE Dijak;