Meta Interview Question

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