Other Habitats - HAS Legal mentions

select habitat_unique_id, sum(legal_status_count) as "has_legal_status_count" FROM (
select habitat_unique_id, count(*) as "legal_status_count"
from [EUNIS].[latest].[Habitat_Legal_Status_Mentioned]
group by habitat_unique_id
UNION
select habitat_unique_id, count(*) as "legal_status_count"
from [EUNIS].[latest].[Habitat_Legal_Status_Relation_Other_Habitats]
group by habitat_unique_id) as "A"
group by habitat_unique_id