Database: government_shift
Question: For each analytical layer, return the analytical layer type code and the number of times it was used.
SQL:
SELECT analytical_layer_type_code ,  count(*) FROM analytical_layer GROUP BY analytical_layer_type_code