IBM Interview Question

Asked how a few various SQL queries worked