첨부 소스 코드는 나눔고딕코딩 폰트를 사용합니다.
728x90
반응형
728x170
WITH StudentSummary AS
(
    SELECT COUNT(*) AS TotalStudentCount FROM Student
)
SELECT
    SchoolID                                                        AS SchoolID,
    COUNT(*)                                                        AS StudentCount,
    COUNT(*) * 1.0 / (SELECT TotalStudentCount FROM StudentSummary) AS StudentRatio
FROM Student
GROUP BY SchoolID;
728x90
반응형
그리드형(광고전용)
Posted by icodebroker

댓글을 달아 주세요