List information for each doctor: doctor_id, full_name, first_day, last_day, where full_name is first_name concatenated with last_name, and first_day and last_day are the doctor's first and last dates of seeing patients. Sort the list by doctor ID ascending.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Aggregate per doctor and use the earliest and latest date columns.