Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

exclude some rows from counts without row_number

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 3, rows affected: 11, absolute service time: 0,22 sec, absolute service time: 0,21 sec 
fork mode |  history
   cityid districtid distinctfamiliynames totalnamesperdistrict
1 Austin 1 3 3
2 Austin 2 2 3
3 Austin 3 1 5