Altimetrik Interview Question

Easy to moderate level SQL question