How to use count in your query

Question

Hi Team

 

I am struggling to get number of times, unit passed(Date-Passed column from Checkpoint-Movement table), PNR(column from Checkpoint-Movement table), Station Description(column from Station table). Given to the below tables; I want to filter between 06:00am-20:00pm today

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [Station Code]
      ,[Machine Name]
      ,[Station Description]
      ,[IP Address]
      ,[Tracking Client Name]
      ,[Previous Station Code]
      ,[Next Station Code]
      ,[Transaction Code]
      ,[SQL_Instance]
      ,[rowguid]
  FROM [Tracking_Server_DB].[dbo].[TS_Station]

SELECT TOP 1000 [Plant Code]
      ,[Production Year]
      ,[PNR]
      ,[KNR]
      ,[Colour]
      ,[Model Code]
      ,[Market]
      ,[Country]
      ,[Transaction Code]
      ,[DateTime Passed]
      ,[Telegram]
      ,[Hold Get]
      ,[Option Code 1]
      ,[EQS Carstate]
      ,[SeqNum]
      ,[RBSCode]
      ,[Return_CP_Name]
  FROM [Tracking_Server_DB].[dbo].[Checkpoint Movement]