Interview Query

Released Patients

Start Timer

0:00:00

Upvote
3
Downvote
Save question
Mark as completed
View comments (12)
Next question

A hospital is studying patient flows to optimize their resource placement.

Write a query to find all dates where the hospital released more patients than the day prior.

Note: You may assume that the table has no missing dates.

Input:

released_patients table

Column Type
release_date DATE
released_patients INTEGER

Output:

Column Type
release_date DATE
released_patients INTEGER
.
.
.
.
.


Comments

Loading comments...