...
| SQL | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||
SELECT to_char(sum(fields),'FM999,999,999,999,999') as "Total retrieved fields", to_char(sum(requests), 'FM999,999,999,999,999') as "Total user requests", to_char(sum(delivered/1024^4), 'FM999.999') as "Delivered volume [TB]"
FROM datasets_stats_monthly
WHERE datasets_stats_monthly.dataset='tigge-glob' and datasets_stats_monthly.month>=date'20061001'; |
...