Next on the menu – advanced aggregation operators

In this longer SQL Snacks™ we will examine some advanced aggregation operators namely:
make_set, make_list, mv-expand, percentiles, top-nested, min, max, arg_min, arg_max, dcount, dcountif, countif, sum, sumif, and any()

The video is too long so I have created two parts.
Part 1

Part 2