Снежинка — Не может быть вложена в другую оконную функцию

#window #snowflake-cloud-data-platform Вопрос: SELECT BEST_CAV_BUSINESS_UNIT_NAME, SCMS_NAME , SUM(TOTAL_ACV - MULTI_YEAR_COMPONENT_OF_ACV) OVER (PARTITION BY BEST_CAV_BUSINESS_UNIT_NAME, QUARTER_WITH_YEAR) AS Bookings_Net , ROW_NUMBER() OVER (ORDER BY Bookings_Net DESC) FROM SBG_DB.SBG_SBGIOPS_BV.BV_SECURITY_SUBSCRIPTION_TOP_CUSTOMERS_FOR_ACV where EDITION IS NOT…