Merge API Interview Question

very basic questions about sql and etl