Calculate each patient's current age (in years). Display patient_id, first_name, birth_date and the exact age based on the current date (age). The results are sorted by patient_id in ascending order, with column names and order matching the expected output.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
PostgreSQL has a function that returns the interval between two dates. Extract the years from it.