Pr 19:17 He who is kind to the poor lends to the LORD, and
he will reward him for what he has done. (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" = '2451' 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