SQL SERVER | MSSQL | How to find maximum and minimum sequence values of Category

Published --