--Query: 			Overview information for Flexibility Service Providers on which zones are or will shortly be open for procurement
--Data set: 		Flexibility
--Organisation:		National Grid Electricity Distribution – DSO
--Date created:		16/06/2021
--Last updated:		21/08/2023

SELECT
	 CMZ_CODE						as 'CMZ Code'
	,FRIENDLY_NAME					as 'CMZ Name'
	,'HV Zone'						as 'Zone Level'
	,LICENCE_AREA					as 'Licence Area'
	,PRODUCT						as 'Main Flexibility Product'
	,SERVICE_OVERVIEW				as 'Service Overview'

FROM CMZ_INFORMATION

WHERE CMZ_INFORMATION.TRANCHE_STATUS = 'PROCUREMENT'

ORDER BY CMZ_INFORMATION.CMZ_CODE
