Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
3. The Treatment Table
The Final Quiz
You’ve Completed the Windows Function Course!


Good. Now, let's look at the more interesting table.


Select all the information from the Treatment table.

Each Treatment contains the following information:

  • Id,
  • TreatmentDate,
  • DoctorId,
  • PatientId (we won’t work with the Patient table, but the column is kept for completeness),
  • Category (e.g. dermal treatment, gastrointestinal treatment, etc.),
  • Name,
  • Price,
  • Score – a number from 0 to 100 and is based on another doctor’s evaluation of that treatment.