IBM interview question

Asked how a few various SQL queries worked