HeyJobs interview question

Asking about diff data lake and datawarehouse? Python skills Sql about window and aggregate function