use DST18000Suffix
--Active Student Count
SELECT COUNT(*),SC
FROM STU
WHERE  DEL = 0 --AND NG < 13 and sc < 101
GROUP BY SC
ORDER BY SC

--Review Schools - LOC
SELECT * FROM LOC
--Schools to SKIP () - 
--SC IN (220,230,240,250,261,270,271,272,280,290,311)  Summer Schools (312,351)
--Inactive School - 999
--Review Last day of school
select * from day
order by  dt desc

--Review NS = 0 
--Four students 4107988,4109972,4109978,4109977
--Three were pre-enrolled
SELECT SC AS [School],NS AS [Next School],ID AS [StudentID],SN AS [STU#],
GR AS [GR],NG AS [Next GR],
CU AS [TCH/CNSLR],NT AS [Next TCH],
SP AS [Prog],NSP AS [Next Prog],
AP1 AS [Att Prog],NP1 AS [Next Att Prog],
AP2 AS [Att Prog2],NP2 AS [Next Att Prog2],
RS AS [Resident SC],NRS AS [Next Resident SC],
IT AS [Int Transfer],NIT AS [Next Int Transfer],
ITD AS [Int Trans District],NTD AS [Next Int Trans District],
EOY AS [End of Year],
HSG AS [Grad Type],
DG AS [Grad Date],
TG AS [Status],
LN AS [Last Name],
FN AS [First Name],
LD AS [Exit Date],
DEL AS [DEL Tag]
FROM STU
where (tg = ' ' or tg = '*') and del = 0 and ns = 0 and SC < 101 AND NG < 13