Simons Foundation interview question

Name and describe SQL JOINs.