Collaborate to determine how to perform the following compound queries on the database's Clinical Table:
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?