gistfile1.txt

SELECT MONTHNAME(Application.created_at) as "Month", YEAR(Application.created_at) as "Year", COUNT(*) as "NUmber of Apps"
FROM Application
JOIN UserApplication ON Application.id = UserApplication.Application_id
JOIN User ON UserApplication.User_id = User.id
AND User.email NOT LIKE '%@engineyard.com'
GROUP BY MONTH(Application.created_at), YEAR(Application.created_at)
ORDER BY YEAR(Application.created_at) DESC, MONTH(Application.created_at) DESC