BlueGreycalmElegant

Català-Valencià – Catalan中文 – Chinese (Simplified)中文 – Chinese (Traditional)Česky – CzechDansk – DanishNederlands – DutchEnglish – EnglishSuomi – FinnishFrançais – FrenchDeutsch – Germanעברית – Hebrewहिंदी – HindiMagyar – HungarianBahasa Indonesia – IndonesianItaliano – Italian日本語 – Japanese한국어 – KoreanМакедонски – Macedonianमराठी – MarathiNorsk – NorwegianPolski – PolishPortuguês – PortuguesePortuguês – Portuguese (Brazil)Русский – RussianSlovenčina – SlovakSlovenščina – SlovenianEspañol – SpanishSvenska – SwedishTürkçe – TurkishУкраїнська – UkrainianOëzbekcha – Uzbek

Compare Revisions

• This comparison shows the changes necessary to convert path

  → /TrafficCount/trunk/sql/report_simple.sql @ 964

  → /TrafficCount/trunk/sql/report_simple.sql @ 965

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

Ignore whitespace Rev 964 → Rev 965

/TrafficCount/trunk/sql/report_simple.sql
0,0 → 1,29
select extract(month from stamp) as month, round((base + delta) / 1024 / 1024)
from tcount
where source = 'tun0_out'
and host = 'sun'
and stamp in (
select max(stamp) from tcount
where source = 'tun0_out'
and host = 'sun'
and extract(year from stamp) = 2003
group by extract(month from stamp)
)
order by month;
select extract(day from stamp) as day, round((base + delta) / 1024 / 1024)
from tcount
where source = 'tun0_out'
and host = 'sun'
and stamp in (
select max(stamp) from tcount
where source = 'tun0_out'
and host = 'sun'
and extract(year from stamp) = 2003
and extract(month from stamp) = 8
group by extract(day from stamp)
)
order by day;