• Collaborate to determine how to perform the following compound queries on the database's ClinicalTable:
• Identify patients over the age of 50 whose chief complaint is chest pain.
• Identify patients with known drug allergies who have been admitted as a result of a motor vehicle collision (MVC).
• What was the average wait time for patients diagnosed with pneumonia before they were administered an antibiotic?