If statement inside of a query

below is an example document I have shared:

http://ift.tt/2bgxjfe

I want to do the following:

for starting cell K7 on patient tab I want to query the call log tab for two main conditions

First: if text colC equals text in patient tab cell c7 AND col D says "No beds Available" And colI shows time left to calling greater than 0 Than return rows D,E,F,A

If not than: if col B=cell H3 in patient tab, and Col C= Cell C7 in patient tab than return rows D,E,F,A

Thank you for your help