如果您需要sum(distance) by movement_kind和sum(distance) by movement_date搭配单一查询。您可能想要搭配SQLiteDatabase.rawQuery()搭配类似下列的查询使用：

select movement_kind, 
       null as movement_date, 
       sum(distance) as distance 
  from s7 
 group by movement_kind
union all
select null, 
       movement_date, 
       sum(distance) 
  from s7 
 group by movement_date;

结果如下所示：

movement_kind|movement_date|distance|
-------------+-------------+--------+
run          |             |     6.0|
walk         |             |    15.0|
             |   2022-12-01|     5.0|
             |   2022-12-02|     3.0|
             |   2022-12-03|     4.0|
             |   2022-12-04|     4.0|
             |   2022-12-05|     5.0|

在应用程序代码中，需要检查movement_kind或movement_date是否为NULL。如果是，则distance中的值将按另一列分组。
示例数据：

create table s7 (
    movement_kind   text,
    distance        float,
    movement_date   date);
    

insert into s7
values
('walk', 5, '2022-12-01'),
('walk', 3, '2022-12-02'),
('walk', 1, '2022-12-03'),
('walk', 2, '2022-12-04'),
('walk', 4, '2022-12-05'),
('run' , 3, '2022-12-03'),
('run' , 2, '2022-12-04'),
('run' , 1, '2022-12-05');