1. 单表查询,并统计数量 SELECT COUNT(*) FROM ven_management.ven_info WHERE ven_operator_name = '自动化测试Admin' and ven_type = 1001;