How to Return Results for Each Select Case Option Even When Count is 0 or Rows Not Found Using T-SQL

Extracting Hours, Minutes, and Seconds from Time Differences in SQL Server