WITH cte
AS ( SELECT
--ROW_NUMBER() OVER ( PARTITION BY StuID ORDER BY BZList.BZInputTime ) pid, --ROW_NUMBER(
WITH cte
AS ( SELECT
--ROW_NUMBER() OVER ( PARTITION BY StuID ORDER BY BZList.BZInputTime ) pid, --ROW_NUMBER(