MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table parking_agent_logs (
 id int auto_increment primary key, 
 `date` date not null, 
 `time` varchar(5) not null, 
 AgentID int not null, 
 Event_Type varchar(30) not null, 
 ParkingID int not null
)
insert into parking_agent_logs  
(`date`, `time`, AgentID, Event_Type, ParkingID) values
  ('2012-06-02', '10:56', 150, 'Log In', 2161)
, ('2012-06-02', '10:56', 150, 'Log In', 2161)
, ('2012-06-02', '10:56', 150, 'Ticket Finished', 2161)
, ('2012-06-02', '10:56', 150, 'Log In', 2108)
, ('2012-06-02', '10:56', 150, 'Ticket Finished', 2108)
, ('2012-06-02', '10:56', 150, 'Ticket Finished', 2161)
, ('2012-06-02', '10:56', 150, 'Log In', 2161)
, ('2012-06-02', '10:56', 150, 'Log Out', 2108)
, ('2012-06-02', '10:57', 150, 'Ticket Finished', 2161)
, ('2012-06-02', '10:58', 150, 'Log Out', 2161)
, ('2012-06-02', '10:58', 150, 'Log Out', 2161)

Records: 11  Duplicates: 0  Warnings: 0


SELECT *
FROM parking_agent_logs
ORDER BY `Date`, `Time`, ParkingID, AgentID
, CASE Event_Type 
  WHEN 'Log In' THEN 1
  WHEN 'Ticket Finished' THEN 2
  WHEN 'Log Out' THEN 3
  ELSE 9
  END


id
date
time
AgentID
Event_Type
ParkingID


4
2012-06-02
10:56
150
Log In
2108

5
2012-06-02
10:56
150
Ticket Finished
2108

8
2012-06-02
10:56
150
Log Out
2108

1
2012-06-02
10:56
150
Log In
2161

2
2012-06-02
10:56
150
Log In
2161

7
2012-06-02
10:56
150
Log In
2161

6
2012-06-02
10:56
150
Ticket Finished
2161

3
2012-06-02
10:56
150
Ticket Finished
2161

9
2012-06-02
10:57
150
Ticket Finished
2161

10
2012-06-02
10:58
150
Log Out
2161

11
2012-06-02
10:58
150
Log Out
2161

id	date	time	AgentID	Event_Type	ParkingID
4	2012-06-02	10:56	150	Log In	2108
5	2012-06-02	10:56	150	Ticket Finished	2108
8	2012-06-02	10:56	150	Log Out	2108
1	2012-06-02	10:56	150	Log In	2161
2	2012-06-02	10:56	150	Log In	2161
7	2012-06-02	10:56	150	Log In	2161
6	2012-06-02	10:56	150	Ticket Finished	2161
3	2012-06-02	10:56	150	Ticket Finished	2161
9	2012-06-02	10:57	150	Ticket Finished	2161
10	2012-06-02	10:58	150	Log Out	2161
11	2012-06-02	10:58	150	Log Out	2161