Introduction
3. Table procedure
Final quiz
Revision

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.

Console

Code editor

Result

TableConsole