SQL Interview Questions

To display count (countr_id)
select count(country_id) no_occorence from state group by (country_id) order by no_occorence desc;Source : https://www.youtube.com/watch?v=jd5ognD_4pc&list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR&index=10














