Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
3. Table procedure
Final quiz
Summary

Instruction

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

Exercise

Select all the information from the procedure table.

Each procedure contains the following information: id, procedure_date, doctor_id, patient_id (we are not going to work with the patient table to make things easier, but the column is still there for completeness), category (like: dermal procedure, gastrointestinal procedure...), name, price and score. The last column is a number from 0 to 100 which comes from procedure evaluation by another colleague at the clinic.