uni/inf1300/hw3/oppgave2.txt

1.
SELECT timelistenr, beskrivelse FROM Timelistelinje WHERE timelistenr = 3;

2.
SELECT COUNT(linjenr) FROM Timelistenilje WHERE timelistenr = 3;

3.
SELECT COUNT(timelistenr) FROM Timelistelinje WHERE status != 'utbetalt';

4.
SELECT COUNT(linjenr) FROM Timelistelinje WHERE starttid > sluttid;

5.
SELECT SUM(V.varighet)
AS timer
FROM Timeliste T, Timelistelinje TL, Varighet V
WHERE
	T.timelistenr = TL.timelistenr AND
	T.status != 'utbetalt' AND
	V.linjenr = TL.linjenr;

6.
SELECT DISTINCT (
	SUM(GREATEST(sluttid - starttid, starttid - sluttid)) -
	SUM(pause * interval '1 minute'))
AS timer
FROM Timeliste T, Timelistelinje TL
WHERE
	T.timelistenr = TL.timelistenr AND
	EXTRACT(MONTH FROM TL.startdato) = 7;