bo_reception_process_record表中有process_id，attend，status，people_num字段，现在想根据process_id筛选出来的数据，获取到attend = 2和attend = 1和status = 10和status = 20不同状态下，计算people_num的总数，请帮我写一个sql

好的，以下是根据您的要求写的 SQL 语句：

SELECT 
  SUM(IF(attend = 1 AND status = 10, people_num, 0)) AS attend_1_status_10_num,
  SUM(IF(attend = 1 AND status = 20, people_num, 0)) AS attend_1_status_20_num,
  SUM(IF(attend = 2 AND status = 10, people_num, 0)) AS attend_2_status_10_num,
  SUM(IF(attend = 2 AND status = 20, people_num, 0)) AS attend_2_status_20_num
FROM 
  bo_reception_process_record
WHERE 
  process_id = 'your_process_id';

以上 SQL 语句中，使用了 `IF` 函数对 `people_num` 进行了分类求和，分别计算了 `attend = 1` 且 `status = 10`，`attend = 1` 且 `status = 20`，`attend = 2` 且 `status = 10`，`attend = 2` 且 `status = 20` 四种情况下的总人数。您只需要将 `your_process_id` 替换成您想要筛选的 `process_id` 即可。

相关问题

SELECT SUM(SELECT people_num FROM bo_reception_process_record WHERE attend = 2) attend, SUM(SELECT people_num FROM bo_reception_process_record WHERE attend = 1) unattend, sum(SELECT people_num FROM bo_reception_process_record WHERE status = 10) consumerEntryNumber, sum(SELECT people_num FROM bo_reception_process_record WHERE status = 20) logisticsEntryNumber FROM `bo_reception_process_record` pr WHERE pr.delete_time = 0 AND pr.process_id = 1664162709840809986 请帮我修改成可执行sql

好的，以下是修改后的 SQL 语句：

SELECT 
  SUM(CASE WHEN attend = 2 THEN people_num ELSE 0 END) AS attend,
  SUM(CASE WHEN attend = 1 THEN people_num ELSE 0 END) AS unattend,
  SUM(CASE WHEN status = 10 THEN people_num ELSE 0 END) AS consumerEntryNumber,
  SUM(CASE WHEN status = 20 THEN people_num ELSE 0 END) AS logisticsEntryNumber
FROM 
  bo_reception_process_record
WHERE 
  delete_time = 0 AND process_id = '1664162709840809986';

以上 SQL 语句中，使用了 `CASE WHEN` 函数对 `people_num` 进行了分类求和，分别计算了 `attend = 2`，`attend = 1`，`status = 10`，`status = 20` 四种情况下的总人数。同时，增加了 `delete_time = 0` 和 `process_id = '1664162709840809986'` 的筛选条件。您只需要将 `1664162709840809986` 替换成您想要筛选的 `process_id` 即可。

CAN_FLAG_RXNE在HAL库中找不到定义

对不起，关于`CAN_FLAG_RXNE`未找到定义的情况，这可能是由于您使用的HAL库版本或文档中的一些更新。`CAN_FLAG_RXNE`通常是CAN接收标志位，表示有新的接收数据可用。在某些库版本中，这个常量可能被替换成了其他名称，比如`CAN_FLAG_NEWRXPACKET`或者直接使用枚举值。

检查您的HAL库源码文件，它可能会定义类似这样的结构：

typedef enum {
   CAN_FLAG_IDFiltersChanged = ((uint32_t)1 << 1),
   CAN_FLAG_RXFIFOUnderrun = ((uint32_t)1 << 2),
   CAN_FLAG_TXFIFOUnderrun = ((uint32_t)1 << 3),
   CAN_FLAG_ERRPassive = ((uint32_t)1 << 4),
   CAN_FLAG_ERRWarning = ((uint32_t)1 << 5),
   CAN_FLAG_ERR严重 = ((uint32_t)1 << 6),
   CAN_FLAG_ERRInt = ((uint32_t)1 << 7),  // Error interrupt flag
   CAN_FLAG_RTRx = ((uint32_t)1 << 8),
   CAN_FLAG_RXNE = ((uint32_t)1 << 9), // New data reception flag
   ... // 其他可能的标志位
} CanFlags_TypeDef;

如果确实找不到，建议查阅相关库的官方文档或者更新到最新版本，那里应该能找到正确的定义。