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

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions in PostgreSQL

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.