Clinisys interview question

Basic plsql , sql . Thn sob queries to write , including ctes.