HP Vertica SQL query using the OVER window function combined with a relative date range.

clicks_per_day_w_7d_csum_advsql2.sql

SELECT 
	day,
	clicks,
	SUM(clicks) OVER (order by day range between '7 days' preceding and current row) accumulated_clicks
FROM 
	datamart.fact_network_stats_daily
WHERE 
	network_id = 72
	AND affiliate_country_code = 'FR'
	AND banner_currency_id = 1
	AND YEAR(day) = 2014
ORDER BY 
	day 
LIMIT 200