Pr 24:29 Do not say, "I'll do to him as he has
done to me; I'll pay that man back
for what he did." (NIV)
Numbers here might not be up to date due to latent reindexing...SELECT
c."College Name",
c."Department Name",
c."Course/Program",
course."Units",
course."Course"||' '||course."Number"||' '||course."Curriculum" as "Code",
course."Description",
course."Financial Units",
personnel.last||', '||personnel.first||' '||personnel.middle as "Teacher",
s."Days",
to_char(s."Start Time",'HH12:MIam'::text) as "Start Time",
to_char(s."End Time",'HH12:MIam'::text) as "End Time",
s."Room",
s."Student Count" as "Vacancies",
s."Options",
s."Notes",
c."Course/Program",
c."Department Name",
c."College Name",
c."Department Note",
c."College Approval",
c."VPAA Approval",
c."Allowed Courses Only",
c."Allowed Encoders Only",
c."Prerequisites Logic",
c."Students Can Encode Themselves",
s.classid,
c.subjectid,
s."Teacher ID"
FROM schedule s
INNER JOIN classes c
ON s.classid = c.classid
LEFT JOIN course
ON c.subjectid = course.courseid
AND s."Curriculum" = course."Curriculum"
LEFT JOIN personnel
ON s."Teacher ID" = personnel.personnel_id
WHERE s."Year" = '2223' AND s."Semester" = '0'
ORDER BY
c."College Name",
c."Department Name",
c."Course/Program",
"Teacher",
s."Days",
"Start Time"
# of Students
Running Units
College Name
Department Name
Course/Program
Units
Code
Description
Financial Units
Teacher
Days
Start Time
End Time
Room
Vacancies
Options
Notes
Course/Program
Department Name
College Name
0
Students
Units
Name:
# of Teachers: 1 Average Units/Teacher: 0.00 # of class seats: 0 Average seats/teacher: 0.00 Average seats/nonempty class: 0.00 # of Students: 0