sql - Counting distinct results and how to use sub queries in MySQL -

sql - Counting distinct results and how to use sub queries in MySQL -

having problem figuring out best way this.

my query follows:

select * `datatable` `type` = 'new' , `permit` = 'valid' , year(`issuedate`)='2012' order `owner` asc

this produces individual result set looking for, subset of data, need find out list of individual (distinct) "owners", , how many times occur (count).

i not sure how utilize query sub query , run query on results.

i export results, work on there, have time today , thought i'd help learning proper way this.

mysql sql group-by mariadb