Complex SQL Query

Using the hospital database, write complex SQL query and show the output of the following questions:
Q1. Show all patients information only if there is a patient whose treatment cost is more than 100. [1 Mark]
Answer