pinning him and causing serious injuries, Palma said.

Impairment was believed to be a factor.

The injured man was still in critical condition Friday morning and was awaiting surgery, Palma said. Additional details on his condition were not readily available.

When the man was flown to a hospital late Thursday evening, the Peoria Fire-Medical Department said he had "potentially life-threatening injuries."

Ceschia was booked into a Maricopa County jail on suspicion of two counts of aggravated DUI in a watercraft, two counts of endangerment and one count of aggravated assault, Palma said.

Sean Ceschia's last name was misspelled in earlier versions of this story.Q:

SQL - How to combine rows

I have the following table which looks at calls and attendances. I got this by using union all on a 'calls' and 'attendances' tables and then used row number on the ID and ordered by dates.
Table1:
     Type    | ID | Call/AttendanceDate | RowNum 
 ------------|----|---------------------|-------- 
  Attendance | 12 | 2018-09-16 10:11:00 |     82 
  Call       | 12 | 2018-09-18 14:11:47 |     83 
  Call       | 12 | 2018-10-02 17:26:13 |     84 
  Call       | 12 | 2018-10-05 14:58:31 |  