goeasy interview question

SQL, technical terms, Some thought process