ABC interview question

basics of SQL queries including SELECT, JOIN, INSERT, UPDATE, DELETE, and aggregate functions