Fiserv Interview Question

write quries on case ? given table and find info using joins