SimplifyVMS Interview Question

How to write a SQL for xyz (easy)