| # | Name,A,30 | Pozn,A,255 | SQL,M,250
|
|---|
| 1 | FakturovanΘ firmy | Vybere firmy, kter²m kdy byla vystavena faktura | SELECT ICO AS I╚O, NAZEV AS N┴ZEV, PSC AS PS╚, OBEC FROM ADRESAR, WHERE IDADRESAR IN (SELECT IDADRESAR FROM FAKTURY);, |
| 2 | Firmy od nich₧ faktura | Vybere firmy, od kter²ch kdy byla obdr₧ena faktura | SELECT ICO AS I╚O,NAZEV AS N┴ZEV,PSC AS PS╚,OBEC FROM ADRESAR, WHERE ICO = SOME(SELECT PFAKTURA.xICO FROM PFAKTURA);, |
| 3 | Souhrn pol. faktur v r. 1997 | P°ehled o celkovΘ cen∞ utr₧enΘ za polo₧ky faktur v r. 1997 | SELECT TEXT AS POLOÄKA, SUM(CENA) AS CELKEM_K╚ FROM POLFAKT JOIN FAKTURY, ON POLFAKT.IDFAKTURA=FAKTURY.IDFAKTURA, AND EXTRACT(YEAR FROM FAKTURY.FVYST)=:ROK, GROUP BY TEXT;, ,
|
(.txt)