e.g. select count(model), ???? from table where model="leon"; what can i do? group by model archivist i want to see and all the rows general eg, we have 5 lines with Leon, but we have and 500 others lines , with other models i wanna see the 5 lines with Leon, and the number of all the other lines in one sql query