Every patient who has been discharged at least once receives a password to access their medical record through the website. Build a list (patient_id, temp_password) where temp_password is made of the following, in order: (1) patient_id, (2) the number of characters in the patient's last_name, (3) the patient's birth year. The displayed list is sorted by patient_id in ascending order.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Build the password by concatenating three values, and only for patients who have at least one discharge.