Spectrum Interview Question

Few questions about SQL and how to handle large data