Meta interview question

Given a table in SQL how would you do JOIN, COUNT DISTINCT etc