HP Vertica SQL query using a common table expression (CTE) and window function available in this variant of SQL

revenue_by_client_advsql2.sql

WITH
revenue_by_client
AS
(
	SELECT 
		f.day,
		c.client_country_name,
		c.client_name,
		SUM(f.revenue * er.rate) revenue_euro
	FROM
		datamart.fact_client_stats_daily f
	JOIN datamart.dim_client c
		ON c.client_id = f.client_id
	JOIN datamart.fact_cpop_exchange_rates_daily er
		ON er.source_currency_id = c.currency_id
		AND er.destination_currency_id = 1
		AND er."day" = f."day"
	GROUP BY
		f.day,
		c.client_country_name,
		c.client_name
	HAVING SUM(f.revenue * er.rate) > 0
)

SELECT 
	client_country_name,
	client_name,
	--??? ratio
	revenue_euro,
	sum(revenue_euro) over (partition  by client_country_name) creveuro,
	sum(revenue_euro) over (partition  by day, client_country_name) ratio

FROM 
	revenue_by_client
WHERE 
	day = CURRENT_DATE - 1
ORDER BY 
	ratio DESC
LIMIT 10