COUNT() http://www.w3schools.com/sql/sql_func_count.asp

ed IINER JOIN http://www.w3schools.com/sql/sql_join_inner.asp