Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
3. Table procedure
Final quiz


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


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.