Pr 14:2 He whose walk is upright fears the LORD, but he
whose ways are devious despises him. (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" = '2238' 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