adams12=# select d.name, dv.description FROM student_demographic_value sv JOIN demographic_value dv ON (sv.demographic_value_id = dv.id) JOIN demographic d ON (d.id = dv.demographic_id) WHERE sv.sid='752181' AND now() >= sv.start_date AND now() < COALESCE(sv.end_date, 'infinity');
   name    | description
-----------+-------------
 Ethnicity | Caucasian
 Gender    | Female
 Language  | E - English
(3 rows)