count e select in una query

[meganoide]

continua a mostrare 0:

count(username)-1  	 username
                0 	 nick123