-- ZADANIE 1
SELECT OSOBA.NAZWISKO ,US.NU
FROM OSOBA
JOIN OS_US
ON OS_US.US= OSOBA.US
JOIN US
ON US.REFERENCE= OS_US.US


-- CW 1.1
SELECT DISTINCT MIASTO FROM KH

-- CW 1.2
SELECT KON as "Konto ", "SUM"*0.257858 AS "Kwota w USD" FROM POZ

-- CW 1.3
SELECT KON AS "KONTO", "SUM" AS "Kwota" ,floor("SUM") AS "Kwota zaokraglona"
FROM POZ WHERE floor("SUM")!="SUM"

-- CW 2.1
SELECT TOP 1 current_date AS 'Data', current_time AS 'Godzina'
FROM DOK

-- CW 2.2
select KON, case when KON LIKE '7%'  then 'Sprzedaż' WHEN KON LIKE '2%'  then 'Rozrachunki' ELSE 'Pozostałe'   end as Typ from POZ

-- CW 2.3
SELECT NAZ, MIASTO, UL, REPLACE(REPLACE(REPLACE(TEL,'+',''),'-',''),' ','') FROM KH

-- CW 2.4
SELECT DOK.NK, DOK.ZAR, DOK.WYS, SUBSTR(DOK.ZAR,0,POSITION(':' IN DOK.ZAR)-1)  FROM DOK WHERE WYS is null

-- CW 3.1
select PIERWSZE, NAZWISKO, KOD, ZD  from  OSOBA  JOIN ZAW USING(ZAW.REFERENCE,OSOBA.ZAW)

-- CW 3.2.1
SELECT DOK.NK, DOK.REJ, DOK.WYS, DOK.DTO FROM DOK WHERE DTO BETWEEN 2012/01/1 AND 2012/01/20  ORDER BY DOK.NK, DOK.DTO

-- CW 3.2.2
SELECT DOK.NK, DOK.REJ, DOK.WYS, DOK.DTO FROM DOK ORDER BY DOK.NK, DOK.DTO

-- CW 3.3
SELECT DOK.NK, DOK.REJ, DOK.WYS FROM DOK JOIN POZ USING(POZ.DOK,DOK.REFERENCE) ORDER BY POZ
SELECT DOK.NK, DOK.REJ, DOK.WYS FROM DOK ORDER BY DOK.DTO

-- CW 4.1
select SUM((cast(DO as INTEGER_TYPE)-cast(OD as INTEGER_TYPE))) as SUMA  from N
-- CW 4.2
SELECT ,REFERENCE as ref FROM @DOK WHERE REFERENCE BETWEEN 'doku0401' and 'doku0405' ORDER BY 2

-- CW 4.3
SELECT KON,SUM('SUM')   FROM POZ WHERE ZK='T'  GROUP BY KON