With nyc_schools as (
SELECT
	child_organization_id AS school_id
FROM
	report.organization_hierarchy
	INNER JOIN
		dw.dimorganization ON child_organization_id = organizationid
WHERE
	parent_organization_id      = '8a97b09d3d96517f013fad817713497a'
	AND child_organization_type = 'SCHOOL'
),
login_data as (
SELECT trunc(eventoccurrencedatetime) as event_date, count(sessionid), dimuserenrollment.role_type from dw.learningevent eve 
	LEFT JOIN nyc_schools sch on eve.organizationid = sch.school_id
    INNER JOIN report.dim_organization_user_enrollment AS dimuserenrollment ON eve.actorid = dimuserenrollment.user_id
    AND dimuserenrollment.role_type in ('TEACHER','STUDENT') 
WHERE 
	eventoccurrencedatetime between '2020-02-03' and '2020-02-04'
	AND eventtype in ('login')
	--AND  eve.objecttype in ('application-session')
	GROUP BY trunc(eventoccurrencedatetime) , dimuserenrollment.role_type
) select * from login_data;