7 lines
289 B
SQL
7 lines
289 B
SQL
SELECT
|
|
alltable.ACTUAL_DEST as Lane,
|
|
concat(round(COUNT(*)/COUNT(*) * 100,2),'%') AS Total_count,
|
|
concat(round(SUM(alltable.DivertStatus = 5)/COUNT(*) * 100,2),'%') AS DestFull_count
|
|
FROM alltable
|
|
Where (alltable.t_stamp BETWEEN :starttime AND :endtime)
|
|
GROUP BY (alltable.ACTUAL_DEST) |