TEG Analytics interview question

mostly about projects and SQL basic questions