...
SQL | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||
SELECT rtrim(to_char(sum(delivered/1024^4), 'FM999999999999990FM999,999,999,990.999'), '.') as "Delivered data volume [TB]", to_char(sum(fields),'FM999,999,999,999,999') as "Number of retrieved fields", to_char(sum(requests), 'FM999,999,999,999,999') as "Number of user requests" FROM datasets_stats_monthly WHERE datasets_stats_monthly.dataset='yopp' and datasets_stats_monthly.month>=date'20170701'; |
...