I am not sure how to make my query group and count if certain values are found in the OrderID column.Here is what I have so far.Select FirstName, LastName, Count(OrderID) as PT, Count(OrderID) as TO, Count(OrderID) as TSFrom TrackingWhere OrderID in ('PT', 'TO', 'TS')Group by FirstName, LastName
Here is an example of the tableFirstName LastName OrderIDBilly Smith PTBilly Smith PTBilly Smith TOSally Smith PTSally Smith TSSally Smith TSHere is what I would like from the output of my queryFirstName LastName PT TO TSBilly Smith 2 1 0Sally Smith 1 0 2