Wise Interview Question

Count and group items using SQL advanced functions