27 lines
708 B
SQL
27 lines
708 B
SQL
-- 检查成长记录表中的数据
|
||
SELECT
|
||
id,
|
||
order_id AS '订单ID',
|
||
teacher_id AS '陪伴员ID',
|
||
student_id AS '学生ID',
|
||
student_name AS '学生姓名',
|
||
record_date AS '记录日期',
|
||
record_type AS '记录类型',
|
||
LEFT(content, 50) AS '反馈内容（前50字）',
|
||
LEFT(supplement, 50) AS '管理师补充（前50字）',
|
||
create_time AS '创建时间',
|
||
update_time AS '更新时间'
|
||
FROM growth_record
|
||
WHERE deleted = 0
|
||
ORDER BY create_time DESC
|
||
LIMIT 20;
|
||
|
||
-- 统计成长记录数量
|
||
SELECT
|
||
record_type AS '记录类型',
|
||
COUNT(*) AS '数量',
|
||
COUNT(supplement) AS '已补充数量'
|
||
FROM growth_record
|
||
WHERE deleted = 0
|
||
GROUP BY record_type;
|