SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table caruse (carid int, kms int);
insert into caruse (carid, kms) select 1, 10;
insert into caruse (carid, kms) select 1, 50;
insert into caruse (carid, kms) select 2, 5;
insert into caruse (carid, kms) select 2, 3;
insert into caruse (carid, kms) select 3, 0;
SELECT A.CarID, A.TotalDist, 
   CASE A.TotalDist
      WHEN A.TotalDist > 50 THEN 'High Kms' 
      WHEN A.TotalDist < 10 THEN 'Low Kms'
   END High_Low
FROM (
   SELECT CarID, SUM(Kms) AS TotalDist
   FROM CarUse
   GROUP BY CarID
) AS A


CarID
TotalDist
High_Low


1
60
null

2
8
null

3
0
High Kms


SELECT A.CarID, A.TotalDist, 
   CASE
      WHEN A.TotalDist > 50 THEN 'High Kms' 
      WHEN A.TotalDist < 10 THEN 'Low Kms'
   END High_Low
FROM (
   SELECT CarID, SUM(Kms) AS TotalDist
   FROM CarUse
   GROUP BY CarID
) AS A


CarID
TotalDist
High_Low


1
60
High Kms

2
8
Low Kms

3
0
Low Kms