Clinic SQL Exercises
- List the physicians working in the clinic. (name)
- List the names and addresses of the patients. (name, address)
- List the dates of all appointments of patient 12345. (date)
- What are the existing conditions in the database in alphabetical order? (designation)
- What patients were seen on January 1, 2007? (number, name)
- What conditions were diagnosed in appointment number 456? (designation)
- How many appointments took place on January 1, 2007? (number)
- How many times was each room used? (room, number)
- How many times was each room used by the physician with the number 99030? (room, number)
- How many times was each room used by the physician Luca Moore? (room, number)
- What rooms were used more than twice on 1 January 2007? (room)
- What are the three most used rooms on that same day? (room)
- What conditions have been diagnosed for patient 12345? (designation)
- What patients have been diagnosed with conditions that have also been diagnosed for patient 12345? (name)