How to count DelayCategories?

[dara]

I would like to know how many count of each categories in each year, When I run count, it doesn't work.

[Debayan]

Hi, @Dara Tourt​ , When you say it does not work, what is the error? You can run count aggregate function.

https://docs.databricks.com/sql/language-manual/functions/count.html

Please let us know if this helps.