Cognizant Interview Question

SQL joins and how to handle date functions