upit nije izvrsen zbog:
- broj greske=1054
- greska=Unknown column 't2.cijena' in 'field list'
- upit=
CREATE TEMPORARY TABLE ts (
sektor int(11) default NULL,
industrija int(11) default NULL,
code varchar(8) default NULL,
a double default NULL,
b double default NULL
) ENGINE=MEMORY (
SELECT t0.sektor AS sektor, t0.industrija AS industrija, t0.code AS code, sum(t2.cijena * income.dilutedavg) AS a, sum(t3.fcf4t) AS b,
t0.industrija_naziv AS industrija_naziv, t0.sektor_naziv AS sektor_naziv, t0.firma_naziv AS firma_naziv
FROM (
select lastFY, zadnjiTM, kratica as code, firma AS firma_naziv, naslovi.sektor AS sektor, sektor.naziv AS sektor_naziv, naslovi.industrija AS industrija, industrija.naziv AS industrija_naziv, guidance_RY, guidance_EY
from naslovi, sektor, industrija
where zadnjiTM >= (select max(zadnjiTM) from naslovi) - 50 AND naslovi.sektor = sektor.sektor AND naslovi.industrija = industrija.ind
) as t0,
current
WHERE t0.code = current.code
GROUP BY t0.sektor, t0.industrija, t0.code WITH ROLLUP
)