Days Between Consecutive Admissions

Postgres Engine
Database Schema
Question (#69)
For patients admitted more than once, calculate the number of days between one admission and the next. The displayed list include columns: patient_id, admission_date, admission_delta is sorted by patient_id and admission_date in ascending order.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Compare each admission with the previous one for the same patient.
Official Solutions
Select a solution...