Sound Physicians Interview Question

Write out some SQL queries to achieve some functions.