Pr 19:7 A poor man is shunned by all his relatives-- how
much more do his friends avoid him! Though he
pursues them with pleading, they are nowhere to be
found. (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" = '2180' 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