Join Patients With Province Names

Postgres Engine
Database Schema
Question (#31)
Display (first_name, last_name, province_name) for all patients. Sort the display list alphabetically by first_name and last_name.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
The province name is stored in a separate table that shares a key with patients.
Official Solutions
Select a solution...