SELECT forename , COUNT(forename) AS popularity
FROM 					(
							SELECT SUBSTRING(name FROM 1 FOR POSITION(' ' IN name) - 1) AS forename
							FROM person
							WHERE name LIKE '% %'
							UNION ALL
							SELECT name AS forename
							FROM person
							WHERE name NOT LIKE '% %'
	    	      ) AS list_of_forenames
GROUP BY forename
HAVING COUNT(forename) > 1
ORDER BY popularity DESC, forename ASC