XYZ       MIA       PBI      some@email.com    11:15am
XYZ       PBI       MIA      some@email.com    11:15am
XYZ       PBI       MIA      some@email.com    2:15pm
XYZ       MIA       PBI      some@email.com    2:15pm

select Distinct(Count(b.RecordLocator)) as "LongHaul"
, b.EmailAddress
from "REZ-RideHistory" as b
where b.DepartStation NOT LIKE '%L%'
and b.ArriveStation NOT LIKE '%L%'
group by b.Recordlocator, b.EmailAddress


select Distinct(Count(b.RecordLocator)) as "LongHaul", b.EmailAddress
from "REZ-RideHistory" as b
where (b.DepartStation = "PBI" and b.ArriveStation = "MIA")
or (b.DepartStation = "MIA" and b.ArriveStation = "PBI")
group by b.Recordlocator, b.EmailAddress