cnct_countryfact_soef20_3_3_1_bioeco_Countries_NWFPs_marketed_value_only_total

SELECT ( SUM(COALESCE([marketed_value],0)) / 1000000 ) AS [Marketed_value],
       NUTS_CODE,
       country,
       currency,
       nwfp_category,
       isTotal
FROM
[FISE].[latest].[v_countryfact_soef20_3_3_1_bioeco_countries_nwfps_marketed_value]
WHERE isTotal=1
GROUP BY NUTS_CODE, country, currency, nwfp_category, isTotal
ORDER BY isTotal asc,Marketed_value desc