LTM Limited interview question

1. Reduce and reduce by key difference 2. Map Vs Flat Map 3. SQL joints