ING interview question

Oracle queries about aggregate function