Merge API interview question

very basic questions about sql and etl