Site regulatory information

SELECT siteInspireId,
    siteName,
    CountryCode,
    euregReportingYear,
    regulatedActivities,
    entityStatus,
    seveso
FROM [IED].[DB_VERSION].[Browse8Header]
GROUP BY siteInspireId,
    siteName,
    CountryCode,
    euregReportingYear,
    regulatedActivities,
    entityStatus,
    seveso