ADP interview question

sql based on scenarios such as giving example tables?