Clark C. Evans avatar Clark C. Evans committed d1c58d0

adding tests in tutorial to regression

Comments (0)

Files changed (3)

     http://demo.htsql.org
     /course?title!='Organic Chemistry Laboratory I'
 
-To find entries that match a string at the beginning (PS5_), use the
-*starts-with* operator (``^~``)::
-
-    /school?name^~'school'
-
-    school                                    
-    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-    code | name                    
-    -----+-------------------------
-    art  | School of Art and Design
-    eng  | School of Engineering   
-    ...      
-
-.. _PS5:
-    http://demo.htsql.com
-    /school?name^~'school'
-
-The *ends-with* operator (``$~``) does the same thing, but from the end
-of the entry (PS6_)::
-     
-    /department?name$~'engineering'
-
-    department                             
-    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-    code | name                   | school |
-    -----+------------------------+--------+
-    be   | Bioengineering         | eng    |
-    ee   | Electrical Engineering | eng    |
-    ...
-
-.. _PS6:
-    http://demo.htsql.com
-    /department?name$~'engineering'
-
 
 Comparison Operators
 --------------------
 The *equality* (``=``) and *inequality* (``!=``) operators are
 straightforward when used with numbers (PC1_)::
 
-    /course{department,number,title}?number=367
-
+    /course{department,number,title}?number=101 
+ 
     course                                                 
-    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-    department | number | title                           
-    -----------+--------+---------------------------------
-    tched      | 367    | Problems in Education Management
+    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+    department | number | title                      
+    -----------+--------+----------------------------
+    eng        |    101 | Introduction to Composition
+    mth        |    101 | College Algebra            
+    ...
 
 .. _PC1:
     http://demo.htsql.org
-    /course{department,number,title}?number=367
+    /course{department,number,title}?number=101
 
 Use the *greater-than* (``>``) operator to request courses with more
 than 3 credits (PC2_):: 
     http://demo.htsql.org
     /course?!(department='arthis'|department='stdart')
 
+Equivalently, using ``={}`` list notation (PB5_)::
+
+    /course?department!={'arthis','stdart'}
+
+.. _PB4:
+    http://demo.htsql.org
+    /course?department!={'arthis','stdart'}
 
 Empty Strings and NULLs
 -----------------------
     http://demo.htsql.org
     /department?school==null()
 
+The ``!==`` operator lists the *complement*, including records with a
+ ``NULL`` for the field tested (PN4_)::
+
+    /department?school!=='art'
+
+    department
+    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+    code   | name                   | school
+    -------+------------------------+-------
+    acc    | Accounting             | bus   
+    astro  | Astronomy              | ns    
+    be     | Bioengineering         | egn   
+    bursar | Bursar's Office        |       
+    capmrk | Capital Markets        | bus   
+    ...
+
+.. _PN4:
+    http://demo.htsql.org
+    /department?school!=='art'
+

test/input/pgsql.yaml

     - uri: /course{department as 'Dept Code'+, number as 'No.', 
                    credits-, title}
     - uri: /program{school.name, title}
+    - uri: /program?degree={'ba','bs'}
     - uri: /course{department.school.name, department.name, title}
     - uri: /department{*,school.*}
     - uri: /department?school='egn'  
     - uri: /department{name, course.credits} # invalid plural join
       expect: 400
     - uri: /department{name, max(course.credits)} 
-
+    - uri: /department{name, count(school)} # invalid singular join
+      expect: 400
+    - uri: /max(course.credits)
+    - uri: /school{name, count(program), count(department)}
+    - uri: /department{name, count(course?number>=400)}
+    - uri: /school{name, avg(department.count(course))}
+    - uri: /school{name, count(department?exists(course?credits>3))}
+    - uri: /department{name, avg((course?number>400).credits)}
+    - uri: /department{code, min(course.credits), 
+              max(course.credits), avg(course.credits)}
+    - uri: /department{name, avg(course.credits), count(course)} 
+              ?every(course.credits=3)
+    # Predicate Expressions
+    - uri: /course?title='Drawing'
+    - uri: /course?title~'lab'
+    - uri: /course?title!= 'Organic Chemistry Laboratory I'
+    - uri: /course{department,number,title}?number=101
+    - uri: /course?credits>3
+    - uri: /course?credits>=3
+    - uri: /department?code>'me'
+    - uri: /{true(), false(), null()}
+    - uri: /department{code, name}?is_null(school)
+    - uri: /department{code, name}?!is_null(school)
+    - uri: /course?department='acc'&credits<3
+    - uri: /course?credits>4|credits<3
+    - uri: /{true()|false()&false(),(true()|false())&false()} 
+    - uri: /course?(department='arthis'|department='stdart')&credits>3
+    - uri: /course?department='arthis'|department='stdart'&credits>3
+    - uri: /course?!(department='arthis'|department='stdart')
+    - uri: /course?department!={'arthis','stdart'}
+    - uri: /course?description
+    - uri: /course{department,number,description}? !description
+    - uri: /department?school==null()
+    - uri: /department?school!=='art'

test/output/pgsql.yaml

          ----
          /program{school.name,title}
          SELECT "school"."name", "program"."title" FROM "ad"."program" AS "program" INNER JOIN "ad"."school" AS "school" ON (("program"."school" = "school"."code")) ORDER BY "program"."school" ASC, "program"."code" ASC
+    - uri: /program?degree={'ba','bs'}
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (program?degree={'ba','bs'})                                  |
+        -+---------------------------------------------------------------+-
+         | school | code     | title                            | degree |
+        -+--------+----------+----------------------------------+--------+-
+         | art    | uhist    | Bachelor of Arts in Art History  | ba     |
+         | art    | ustudio  | Bachelor of Arts in Studio Art   | ba     |
+         | bus    | uacct    | Bachelor of Science in           | bs     |
+         :        :          : Accounting                       :        :
+         | bus    | ubusad   | Bachelor of Science in Business  | bs     |
+         :        :          : Administration                   :        :
+         | bus    | ucorpfi  | Bachelor of Science in Corporate | bs     |
+         :        :          : Finance                          :        :
+         | edu    | umath    | Bachelor of Arts in Math         | ba     |
+         :        :          : Education                        :        :
+         | edu    | usci     | Bachelor of Arts in Science      | ba     |
+         :        :          : Education                        :        :
+         | egn    | ubio     | Bachelor of Science in           | bs     |
+         :        :          : Bioengineering                   :        :
+         | egn    | ucompsci | Bachelor of Science in Computer  | bs     |
+         :        :          : Science                          :        :
+         | egn    | uelec    | Bachelor of Science in           | bs     |
+         :        :          : Electrical Engineering           :        :
+         | egn    | umech    | Bachelor of Science in           | bs     |
+         :        :          : Mechanical Engineering           :        :
+         | la     | uengl    | Bachelor of Arts in English      | ba     |
+         | la     | uhist    | Bachelor of Arts in History      | ba     |
+         | la     | upolisci | Bachelor of Arts in Political    | ba     |
+         :        :          : Science                          :        :
+         | la     | upsych   | Bachelor of Arts in Psychology   | ba     |
+         | la     | uspan    | Bachelor of Arts in Spanish      | ba     |
+         | mart   | bmart    | Bachelor of Modern Art           | ba     |
+         | ns     | uastro   | Bachelor of Science in Astronomy | bs     |
+         | ns     | uchem    | Bachelor of Science in Chemistry | bs     |
+         | ns     | uphys    | Bachelor of Science in Physics   | bs     |
+                                                                 (20 rows)
+
+         ----
+         /program?degree={'ba','bs'}
+         SELECT "program"."school", "program"."code", "program"."title", "program"."degree" FROM "ad"."program" AS "program" WHERE ("program"."degree" IN ('ba', 'bs')) ORDER BY 1 ASC, 2 ASC
     - uri: /course{department.school.name, department.name, title}
       status: 200 OK
       headers:
          ----
          /department{name,max(course.credits)}
          SELECT "department"."name", "course"."!" FROM "ad"."department" AS "department" LEFT OUTER JOIN (SELECT MAX("course"."credits") AS "!", "course"."department" FROM "ad"."course" AS "course" GROUP BY 2) AS "course" ON (("department"."code" = "course"."department")) ORDER BY "department"."code" ASC
+    - uri: /department{name, count(school)}
+      status: 400 Bad Request
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |
+        invalid argument: a plural operand is required:
+            /department{name, count(school)}
+                              ^^^^^^^^^^^^^
+    - uri: /max(course.credits)
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         |                     |
+        -+---------------------+-
+         | max(course.credits) |
+        -+---------------------+-
+         |                   8 |
+                         (1 row)
+
+         ----
+         /max(course.credits)
+         SELECT MAX("course"."credits") FROM "ad"."course" AS "course"
+    - uri: /school{name, count(program), count(department)}
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | school                                                                |
+        -+-----------------------------------------------------------------------+-
+         | name                             | count(program) | count(department) |
+        -+----------------------------------+----------------+-------------------+-
+         | School of Art and Design         |              3 |                 2 |
+         | School of Business               |              5 |                 3 |
+         | College of Education             |              7 |                 2 |
+         | School of Engineering            |              8 |                 4 |
+         | School of Arts, Letters, and the |              9 |                 5 |
+         : Humanities                       :                :                   :
+         | School of Modern Art             |              1 |                 0 |
+         | Musical School                   |              0 |                 4 |
+         | School of Natural Sciences       |              3 |                 4 |
+         | School of Continuing Studies     |              0 |                 0 |
+                                                                          (9 rows)
+
+         ----
+         /school{name,count(program),count(department)}
+         SELECT "school"."name", COALESCE("program"."!", 0), COALESCE("department"."!", 0) FROM "ad"."school" AS "school" LEFT OUTER JOIN (SELECT COUNT(TRUE) AS "!", "program"."school" FROM "ad"."program" AS "program" GROUP BY 2) AS "program" ON (("school"."code" = "program"."school")) LEFT OUTER JOIN (SELECT COUNT(TRUE) AS "!", "department"."school" FROM "ad"."department" AS "department" GROUP BY 2) AS "department" ON (("school"."code" = "department"."school")) ORDER BY "school"."code" ASC
+    - uri: /department{name, count(course?number>=400)}
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | department                                         |
+        -+----------------------------------------------------+-
+         | name                   | count(course?number>=400) |
+        -+------------------------+---------------------------+-
+         | Accounting             |                         3 |
+         | Art History            |                         4 |
+         | Astronomy              |                         0 |
+         | Bioengineering         |                         2 |
+         | Bursar's Office        |                         0 |
+         | Capital Markets        |                         4 |
+         | Career Development     |                         0 |
+         | Chemistry              |                         1 |
+         | Computer Science       |                         4 |
+         | Corporate Finance      |                         2 |
+         | Educational Policy     |                         3 |
+         | Electrical Engineering |                         3 |
+         | English                |                         1 |
+         | History                |                         2 |
+         | Foreign Languages      |                         0 |
+         | Mechanical Engineering |                         3 |
+         | Mathematics            |                         0 |
+         | Parents & Alumni       |                         0 |
+         | Physics                |                         3 |
+         | Piano                  |                         0 |
+         | Political Science      |                         4 |
+         | Psychology             |                         3 |
+         | Studio Art             |                         5 |
+         | Strings                |                         0 |
+         | Teacher Education      |                         2 |
+         | Vocals                 |                         0 |
+         | Wind                   |                         0 |
+                                                      (27 rows)
+
+         ----
+         /department{name,count(course?number>=400)}
+         SELECT "department"."name", COALESCE("course"."!", 0) FROM "ad"."department" AS "department" LEFT OUTER JOIN (SELECT COUNT(TRUE) AS "!", "course"."department" FROM "ad"."course" AS "course" WHERE ("course"."number" >= 400) GROUP BY 2) AS "course" ON (("department"."code" = "course"."department")) ORDER BY "department"."code" ASC
+    - uri: /school{name, avg(department.count(course))}
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | school                                                           |
+        -+------------------------------------------------------------------+-
+         | name                             | avg(department.count(course)) |
+        -+----------------------------------+-------------------------------+-
+         | School of Art and Design         |            6.5000000000000000 |
+         | School of Business               |            4.3333333333333333 |
+         | College of Education             |            5.0000000000000000 |
+         | School of Engineering            |            5.2500000000000000 |
+         | School of Arts, Letters, and the |            5.4000000000000000 |
+         : Humanities                       :                               :
+         | School of Modern Art             |                               |
+         | Musical School                   |                         0E-20 |
+         | School of Natural Sciences       |            4.0000000000000000 |
+         | School of Continuing Studies     |                               |
+                                                                     (9 rows)
+
+         ----
+         /school{name,avg(department.count(course))}
+         SELECT "school"."name", "department"."!" FROM "ad"."school" AS "school" LEFT OUTER JOIN (SELECT AVG(CAST(COALESCE("course"."!", 0) AS NUMERIC)) AS "!", "department"."school" FROM "ad"."department" AS "department" LEFT OUTER JOIN (SELECT COUNT(TRUE) AS "!", "course"."department" FROM "ad"."course" AS "course" GROUP BY 2) AS "course" ON (("department"."code" = "course"."department")) GROUP BY 2) AS "department" ON (("school"."code" = "department"."school")) ORDER BY "school"."code" ASC
+    - uri: /school{name, count(department?exists(course?credits>3))}
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | school                                                                        |
+        -+-------------------------------------------------------------------------------+-
+         | name                             | count(department?exists(course?credits>3)) |
+        -+----------------------------------+--------------------------------------------+-
+         | School of Art and Design         |                                          2 |
+         | School of Business               |                                          1 |
+         | College of Education             |                                          1 |
+         | School of Engineering            |                                          4 |
+         | School of Arts, Letters, and the |                                          3 |
+         : Humanities                       :                                            :
+         | School of Modern Art             |                                          0 |
+         | Musical School                   |                                          0 |
+         | School of Natural Sciences       |                                          1 |
+         | School of Continuing Studies     |                                          0 |
+                                                                                  (9 rows)
+
+         ----
+         /school{name,count(department?exists(course?credits>3))}
+         SELECT "school"."name", COALESCE("department"."!", 0) FROM "ad"."school" AS "school" LEFT OUTER JOIN (SELECT COUNT(TRUE) AS "!", "department"."school" FROM "ad"."department" AS "department" WHERE EXISTS((SELECT TRUE AS "!" FROM "ad"."course" AS "course" WHERE (("department"."code" = "course"."department") AND ("course"."credits" > 3)))) GROUP BY 2) AS "department" ON (("school"."code" = "department"."school")) ORDER BY "school"."code" ASC
+    - uri: /department{name, avg((course?number>400).credits)}
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | department                                                |
+        -+-----------------------------------------------------------+-
+         | name                   | avg((course?number>400).credits) |
+        -+------------------------+----------------------------------+-
+         | Accounting             |               3.0000000000000000 |
+         | Art History            |               3.2500000000000000 |
+         | Astronomy              |                                  |
+         | Bioengineering         |               5.5000000000000000 |
+         | Bursar's Office        |                                  |
+         | Capital Markets        |               3.0000000000000000 |
+         | Career Development     |                                  |
+         | Chemistry              |               3.0000000000000000 |
+         | Computer Science       |               3.2500000000000000 |
+         | Corporate Finance      |               3.0000000000000000 |
+         | Educational Policy     |               3.0000000000000000 |
+         | Electrical Engineering |               3.3333333333333333 |
+         | English                |               2.0000000000000000 |
+         | History                |               3.0000000000000000 |
+         | Foreign Languages      |                                  |
+         | Mechanical Engineering |               3.3333333333333333 |
+         | Mathematics            |                                  |
+         | Parents & Alumni       |                                  |
+         | Physics                |               3.0000000000000000 |
+         | Piano                  |                                  |
+         | Political Science      |               3.2500000000000000 |
+         | Psychology             |               3.6666666666666667 |
+         | Studio Art             |               3.2000000000000000 |
+         | Strings                |                                  |
+         | Teacher Education      |               3.5000000000000000 |
+         | Vocals                 |                                  |
+         | Wind                   |                                  |
+                                                             (27 rows)
+
+         ----
+         /department{name,avg((course?number>400).credits)}
+         SELECT "department"."name", "course"."!" FROM "ad"."department" AS "department" LEFT OUTER JOIN (SELECT AVG(CAST("course"."credits" AS NUMERIC)) AS "!", "course"."department" FROM "ad"."course" AS "course" WHERE ("course"."number" > 400) GROUP BY 2) AS "course" ON (("department"."code" = "course"."department")) ORDER BY "department"."code" ASC
+    - uri: /department{code, min(course.credits), max(course.credits), avg(course.credits)}
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | department                                                               |
+        -+--------------------------------------------------------------------------+-
+         | code   | min(course.credits) | max(course.credits) | avg(course.credits) |
+        -+--------+---------------------+---------------------+---------------------+-
+         | acc    |                   2 |                   5 |  3.1666666666666667 |
+         | arthis |                   3 |                   4 |  3.1666666666666667 |
+         | astro  |                   1 |                   3 |  2.2500000000000000 |
+         | be     |                   3 |                   8 |  4.2500000000000000 |
+         | bursar |                     |                     |                     |
+         | capmrk |                   3 |                   3 |  3.0000000000000000 |
+         | career |                     |                     |                     |
+         | chem   |                   2 |                   3 |  2.8000000000000000 |
+         | comp   |                   3 |                   4 |  3.1428571428571429 |
+         | corpfi |                   3 |                   3 |  3.0000000000000000 |
+         | edpol  |                   3 |                   3 |  3.0000000000000000 |
+         | ee     |                   3 |                   4 |  3.2000000000000000 |
+         | eng    |                   2 |                   3 |  2.6666666666666667 |
+         | hist   |                   3 |                   3 |  3.0000000000000000 |
+         | lang   |                   2 |                   4 |  3.0000000000000000 |
+         | me     |                   3 |                   4 |  3.4000000000000000 |
+         | mth    |                   5 |                   5 |  5.0000000000000000 |
+         | parent |                     |                     |                     |
+         | phys   |                   2 |                   3 |  2.8333333333333333 |
+         | pia    |                     |                     |                     |
+         | poli   |                   3 |                   4 |  3.1666666666666667 |
+         | psych  |                   3 |                   4 |  3.4000000000000000 |
+         | stdart |                   0 |                   5 |  3.1666666666666667 |
+         | str    |                     |                     |                     |
+         | tched  |                   3 |                   4 |  3.2000000000000000 |
+         | voc    |                     |                     |                     |
+         | win    |                     |                     |                     |
+                                                                            (27 rows)
+
+         ----
+         /department{code,min(course.credits),max(course.credits),avg(course.credits)}
+         SELECT "department"."code", "course"."!_1", "course"."!_2", "course"."!_3" FROM "ad"."department" AS "department" LEFT OUTER JOIN (SELECT MIN("course"."credits") AS "!_1", MAX("course"."credits") AS "!_2", AVG(CAST("course"."credits" AS NUMERIC)) AS "!_3", "course"."department" FROM "ad"."course" AS "course" GROUP BY 4) AS "course" ON (("department"."code" = "course"."department")) ORDER BY 1 ASC
+    - uri: /department{name, avg(course.credits), count(course)} ?every(course.credits=3)
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (department?every(course.credits=3))                     |
+        -+----------------------------------------------------------+-
+         | name               | avg(course.credits) | count(course) |
+        -+--------------------+---------------------+---------------+-
+         | Bursar's Office    |                     |             0 |
+         | Capital Markets    |  3.0000000000000000 |             4 |
+         | Career Development |                     |             0 |
+         | Corporate Finance  |  3.0000000000000000 |             3 |
+         | Educational Policy |  3.0000000000000000 |             5 |
+         | History            |  3.0000000000000000 |             5 |
+         | Parents & Alumni   |                     |             0 |
+         | Piano              |                     |             0 |
+         | Strings            |                     |             0 |
+         | Vocals             |                     |             0 |
+         | Wind               |                     |             0 |
+                                                            (11 rows)
+
+         ----
+         /department{name,avg(course.credits),count(course)}?every(course.credits=3)
+         SELECT "department"."name", "course"."!_1", COALESCE("course"."!_2", 0) FROM "ad"."department" AS "department" LEFT OUTER JOIN (SELECT AVG(CAST("course"."credits" AS NUMERIC)) AS "!_1", COUNT(TRUE) AS "!_2", "course"."department" FROM "ad"."course" AS "course" GROUP BY 3) AS "course" ON (("department"."code" = "course"."department")) WHERE NOT EXISTS((SELECT TRUE AS "!" FROM "ad"."course" AS "course_2" WHERE (("department"."code" = "course_2"."department") AND ("course_2"."credits" != 3)))) ORDER BY "department"."code" ASC
+    - uri: /course?title='Drawing'
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?title='Drawing')                                                   |
+        -+----------------------------------------------------------------------------+-
+         | department | number | title   | credits | description                      |
+        -+------------+--------+---------+---------+----------------------------------+-
+         | stdart     |    333 | Drawing |       3 | Exploration of the structure and |
+         :            :        :         :         : interrelationships of visual     :
+         :            :        :         :         : form in drawing, painting, and   :
+         :            :        :         :         : sculpture. Principal historical  :
+         :            :        :         :         : modes of drawing are examined.   :
+                                                                                (1 row)
+
+         ----
+         /course?title='Drawing'
+         SELECT "course"."department", "course"."number", "course"."title", "course"."credits", "course"."description" FROM "ad"."course" AS "course" WHERE ("course"."title" = 'Drawing') ORDER BY 1 ASC, 2 ASC
+    - uri: /course?title~'lab'
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?title~'lab')                                                                                |
+        -+-----------------------------------------------------------------------------------------------------+-
+         | department | number | title                            | credits | description                      |
+        -+------------+--------+----------------------------------+---------+----------------------------------+-
+         | astro      |    142 | Solar System Lab                 |       2 | Laboratory studies that          |
+         :            :        :                                  :         : complement the lecture course    :
+         :            :        :                                  :         : ASTRO 137.                       :
+         | chem       |    115 | Organic Chemistry Laboratory I   |       2 | Complements Organic Chemistry I. |
+         :            :        :                                  :         : Practical laboratory             :
+         :            :        :                                  :         : experiments.                     :
+         | chem       |    314 | Laboratory Chemistry             |       3 | Experimental chemistry for       |
+         :            :        :                                  :         : students who are planning to     :
+         :            :        :                                  :         : major in chemistry. Covers       :
+         :            :        :                                  :         : principles and applications of   :
+         :            :        :                                  :         : chemical laboratory techniques,  :
+         :            :        :                                  :         : including preparation and        :
+         :            :        :                                  :         : analysis of chemical materials.  :
+         | comp       |    710 | Laboratory in Computer Science   |       4 | Independent research opportunity |
+         :            :        :                                  :         : using the university computer    :
+         :            :        :                                  :         : lab. Requires instructor         :
+         :            :        :                                  :         : permission and may be repeated.  :
+         | ee         |    412 | Laboratory in Electrical         |       4 | Hands-on experience covering     |
+         :            :        : Engineering                      :         : areas of optical transforms,     :
+         :            :        :                                  :         : electro-optics devices, signal   :
+         :            :        :                                  :         : processing, fiber optics         :
+         :            :        :                                  :         : transmission, and holography.    :
+         | psych      |    450 | Laboratory in Applied Behavioral |       4 | This course will provide         |
+         :            :        : Science                          :         : students with hands-on training  :
+         :            :        :                                  :         : in the application of behavioral :
+         :            :        :                                  :         : research technology to a         :
+         :            :        :                                  :         : clinical population.             :
+                                                                                                        (6 rows)
+
+         ----
+         /course?title~'lab'
+         SELECT "course"."department", "course"."number", "course"."title", "course"."credits", "course"."description" FROM "ad"."course" AS "course" WHERE (POSITION(LOWER('lab') IN LOWER("course"."title")) > 0) ORDER BY 1 ASC, 2 ASC
+    - uri: /course?title!= 'Organic Chemistry Laboratory I'
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?title!='Organic Chemistry Laboratory I')                                                    |
+        -+-----------------------------------------------------------------------------------------------------+-
+         | department | number | title                            | credits | description                      |
+        -+------------+--------+----------------------------------+---------+----------------------------------+-
+         | acc        |    100 | Practical Bookkeeping            |       2 |                                  |
+         | acc        |    200 | Principles of Accounting I       |       3 | The initial course in the theory |
+         :            :        :                                  :         : and practice of financial        :
+         :            :        :                                  :         : accounting. Topics emphasized    :
+         :            :        :                                  :         : include the preparation,         :
+         :            :        :                                  :         : reporting, and analysis of       :
+         :            :        :                                  :         : financial data.                  :
+         | acc        |    315 | Financial Accounting             |       5 | Integration of the conceptual    |
+         :            :        :                                  :         : and computational aspects of     :
+         :            :        :                                  :         : asset, liability and             :
+         :            :        :                                  :         : stockholders equity accounting.  :
+         | acc        |    426 | Corporate Taxation               |       3 | Concepts and methods of          |
+         :            :        :                                  :         : determining federal tax          :
+         :            :        :                                  :         : liability of corporations.       :
+         | acc        |    527 | Advanced Accounting              |       3 | Theory and practical             |
+         :            :        :                                  :         : applications of accounting for   :
+         :            :        :                                  :         : consolidated entities and        :
+         :            :        :                                  :         : partnerships; includes foreign   :
+         :            :        :                                  :         : currency transactions, hedging   :
+         :            :        :                                  :         : and derivatives.                 :
+         | acc        |    606 | Corporate Financial Law          |       3 | Law governing business           |
+         :            :        :                                  :         : corporations; fiduciary duties   :
+         :            :        :                                  :         : of managers and directors in     :
+         :            :        :                                  :         : situations such as mergers,      :
+         :            :        :                                  :         : acquisitions, securities         :
+         :            :        :                                  :         : offerings, market domination,    :
+         :            :        :                                  :         : litigation.                      :
+         | arthis     |    202 | History of Art Criticism         |       3 | An introductory survey course on |
+         :            :        :                                  :         : Prehistoric through              :
+         :            :        :                                  :         : late-Medieval art history.       :
+         | arthis     |    340 | Arts of Asia                     |       3 | An introduction to the history   |
+         :            :        :                                  :         : and criticism of Far Eastern     :
+         :            :        :                                  :         : art, including the art of China  :
+         :            :        :                                  :         : and Japan, fine and decorative   :
+         :            :        :                                  :         : arts.                            :
+         | arthis     |    623 | Contemporary Latin American Art  |       3 | A survey of the last twenty      |
+         :            :        :                                  :         : years of Latin American art with :
+         :            :        :                                  :         : a focus on the Caribbean and     :
+         :            :        :                                  :         : Central America.                 :
+         | arthis     |    710 | Methods in Art History           |       3 | This seminar focuses on basic    |
+         :            :        :                                  :         : types of art-historical method.  :
+         :            :        :                                  :         : Some meetings focus on a single  :
+         :            :        :                                  :         : author who exemplifies a         :
+         :            :        :                                  :         : particular approach.             :
+         | arthis     |    712 | Museum and Gallery Management    |       4 | Supervised independent field     |
+         :            :        :                                  :         : experience and practical work in :
+         :            :        :                                  :         : all areas of Art Museum          :
+         :            :        :                                  :         : management in the university and :
+         :            :        :                                  :         : greater metropolitan area        :
+         :            :        :                                  :         : communities.                     :
+         | arthis     |    809 | Materials and Construction in    |       3 | A scientific examination of the  |
+         :            :        : European Art                     :         : materials and manufacturing      :
+         :            :        :                                  :         : techniques employed in Europe    :
+         :            :        :                                  :         : over the last two centuries.     :
+         | astro      |    137 | The Solar System                 |       3 | Introductory survey of the solar |
+         :            :        :                                  :         : system, including structure and  :
+         :            :        :                                  :         : motion of the planets,           :
+         :            :        :                                  :         : properties of the sun, and       :
+         :            :        :                                  :         : comparison to extrasolar         :
+         :            :        :                                  :         : systems.                         :
+         | astro      |    142 | Solar System Lab                 |       2 | Laboratory studies that          |
+         :            :        :                                  :         : complement the lecture course    :
+         :            :        :                                  :         : ASTRO 137.                       :
+         | astro      |    155 | Telescope Workshop               |       1 | Introduction to correct use of   |
+         :            :        :                                  :         : the 8-inch Schmidt-Cassegrain    :
+         :            :        :                                  :         : type telescope. You will learn   :
+         :            :        :                                  :         : about magnification, how to      :
+         :            :        :                                  :         : locate an object, and how        :
+         :            :        :                                  :         : setting circles work.            :
+         | astro      |    254 | Life in the Universe             |       3 | Nature and origin of large       |
+         :            :        :                                  :         : numbers in the cosmos, the       :
+         :            :        :                                  :         : formation of planets, formation  :
+         :            :        :                                  :         : of life, and the anthropic       :
+         :            :        :                                  :         : principle.                       :
+         | be         |    112 | Introduction to Biomedical       |       3 | This course covers topics in     |
+         :            :        : Engineering                      :         : multiple formats ranging from    :
+         :            :        :                                  :         : lectures by faculty or guest     :
+         :            :        :                                  :         : speakers to presentations by     :
+         :            :        :                                  :         : participating students.          :
+         | be         |    308 | Fundamentals of Biochemistry     |       3 | Fundamental aspects of human     |
+         :            :        :                                  :         : biochemistry are introduced in   :
+         :            :        :                                  :         : this course for students in the  :
+         :            :        :                                  :         : bioinstrumentation/biosensors,   :
+         :            :        :                                  :         : biomechanics, and                :
+         :            :        :                                  :         : medical-imaging tracks.          :
+         | be         |    415 | Internship in Biomedical         |       8 | The student will work twenty     |
+         :            :        : Engineering                      :         : hours per week in an area firm   :
+         :            :        :                                  :         : to gain experience in the        :
+         :            :        :                                  :         : application of biomedical        :
+         :            :        :                                  :         : engineering principles in an     :
+         :            :        :                                  :         : industrial setting.              :
+         | be         |    509 | Systems of Drug Delivery         |       3 | The mathematics of diffusion     |
+         :            :        :                                  :         : through various types of         :
+         :            :        :                                  :         : biological media is discussed.   :
+         | capmrk     |    712 | International Financial Markets  |       3 | Offers an understanding of the   |
+         :            :        :                                  :         : international financial          :
+         :            :        :                                  :         : structure and studies its impact :
+         :            :        :                                  :         : on business and individuals in   :
+         :            :        :                                  :         : various nations.                 :
+         | capmrk     |    756 | Capital Risk Management          |       3 | This course introduces           |
+         :            :        :                                  :         : fundamental principles and       :
+         :            :        :                                  :         : techniques of financial risk     :
+         :            :        :                                  :         : management.                      :
+         | capmrk     |    808 | Principles of Portfolio          |       3 | Comprehensive coverage of the    |
+         :            :        : Management                       :         : theory and practice of money     :
+         :            :        :                                  :         : management as well as in-depth   :
+         :            :        :                                  :         : analysis of the theory and       :
+         :            :        :                                  :         : practice involved when           :
+         :            :        :                                  :         : securities are combined into     :
+         :            :        :                                  :         : portfolios.                      :
+         | capmrk     |    818 | Financial Statement Analysis     |       3 | This course presents techniques  |
+         :            :        :                                  :         : for analyzing current and        :
+         :            :        :                                  :         : projected financial statements   :
+         :            :        :                                  :         : for the purposes of credit       :
+         :            :        :                                  :         : analysis, security analysis, and :
+         :            :        :                                  :         : internal financial analysis, and :
+         :            :        :                                  :         : cash flow forecasting.           :
+         | chem       |    100 | Principles of Chemistry          |       3 | This course offers an            |
+         :            :        :                                  :         : introduction to the biological,  :
+         :            :        :                                  :         : inorganic, and chemical          :
+         :            :        :                                  :         : molecules, with an emphasis on   :
+         :            :        :                                  :         : basic principles of atomic and   :
+         :            :        :                                  :         : molecular electronic structure.  :
+         | chem       |    110 | Organic Chemistry I              |       3 | This course offers a practical   |
+         :            :        :                                  :         : introduction to organic          :
+         :            :        :                                  :         : chemistry, including a full set  :
+         :            :        :                                  :         : of problem sets with solutions.  :
+         :            :        :                                  :         : Focus is on the basic principles :
+         :            :        :                                  :         : of understanding the structure   :
+         :            :        :                                  :         : and reactivity of organic        :
+         :            :        :                                  :         : molecules.                       :
+         | chem       |    314 | Laboratory Chemistry             |       3 | Experimental chemistry for       |
+         :            :        :                                  :         : students who are planning to     :
+         :            :        :                                  :         : major in chemistry. Covers       :
+         :            :        :                                  :         : principles and applications of   :
+         :            :        :                                  :         : chemical laboratory techniques,  :
+         :            :        :                                  :         : including preparation and        :
+         :            :        :                                  :         : analysis of chemical materials.  :
+         | chem       |    655 | Protein Folding Problem          |       3 | Focuses on the mechanisms        |
+         :            :        :                                  :         : through which the amino acid     :
+         :            :        :                                  :         : sequence of polypeptide chains   :
+         :            :        :                                  :         : determine their                  :
+         :            :        :                                  :         : three-dimensional conformation.  :
+         | comp       |    102 | Introduction to Computer Science |       3 | This course in an introduction   |
+         :            :        :                                  :         : to the discipline of computer    :
+         :            :        :                                  :         : science. Topics include          :
+         :            :        :                                  :         : algorithmic foundations,         :
+         :            :        :                                  :         : hardware concepts, virtual       :
+         :            :        :                                  :         : machine concepts, software       :
+         :            :        :                                  :         : systems, applications, and       :
+         :            :        :                                  :         : social issues.                   :
+         | comp       |    230 | History of Computing             |       3 | This course will survey the      |
+         :            :        :                                  :         : history of the computing field   :
+         :            :        :                                  :         : from antiquity to the present,   :
+         :            :        :                                  :         : focusing on the era of the       :
+         :            :        :                                  :         : electronic digital computer.     :
+         :            :        :                                  :         : Topics will include historical   :
+         :            :        :                                  :         : developments in hardware,        :
+         :            :        :                                  :         : software, and the theoretical    :
+         :            :        :                                  :         : foundations of computer science. :
+         | comp       |    350 | Introduction to Signal           |       3 | This course covers the nature of |
+         :            :        : Processing                       :         : information, signals,            :
+         :            :        :                                  :         : transforms, and applications.    :
+         :            :        :                                  :         : Topics include analog to digital :
+         :            :        :                                  :         : and digital to analog            :
+         :            :        :                                  :         : conversion, data storage (such   :
+         :            :        :                                  :         : as the audio format MP3), data   :
+         :            :        :                                  :         : transforms, and filters.         :
+         | comp       |    615 | Introduction to Automata         |       3 | Theory of computing devices and  |
+         :            :        :                                  :         : the languages they recognize.    :
+         | comp       |    710 | Laboratory in Computer Science   |       4 | Independent research opportunity |
+         :            :        :                                  :         : using the university computer    :
+         :            :        :                                  :         : lab. Requires instructor         :
+         :            :        :                                  :         : permission and may be repeated.  :
+         | comp       |    810 | Thesis Research                  |       3 | Guided research leading to       |
+         :            :        :                                  :         : production of the thesis.        :
+         :            :        :                                  :         : Requires instructor permission   :
+         :            :        :                                  :         : and may be repeated.             :
+         | comp       |    819 | Advanced Algorithms in           |       3 | This course is focused on        |
+         :            :        : Bioinformatics                   :         : fundamental algorithmic          :
+         :            :        :                                  :         : techniques in Bioinformatics,    :
+         :            :        :                                  :         : including classed methods such   :
+         :            :        :                                  :         : as dynamic programming, support  :
+         :            :        :                                  :         : vector machines and other        :
+         :            :        :                                  :         : statistical and learning         :
+         :            :        :                                  :         : optimization methods.            :
+         | corpfi     |    234 | Accounting Information Systems   |       3 | This course bridges the gap      |
+         :            :        :                                  :         : between two disciplines critical :
+         :            :        :                                  :         : to business operations.  This    :
+         :            :        :                                  :         : course of study teaches students :
+         :            :        :                                  :         : to design and deploy information :
+         :            :        :                                  :         : technology to improve the        :
+         :            :        :                                  :         : accounting systems of an         :
+         :            :        :                                  :         : organization.                    :
+         | corpfi     |    404 | Corporate Financial Management   |       3 | This course covers advanced      |
+         :            :        :                                  :         : topics in corporate financial    :
+         :            :        :                                  :         : management, including its role   :
+         :            :        :                                  :         : in corporate governance.         :
+         | corpfi     |    601 | Case Studies in Corporate        |       3 | A course designed to use case    |
+         :            :        : Finance                          :         : studies and financial analysis   :
+         :            :        :                                  :         : to further knowledge and ability :
+         :            :        :                                  :         : to make financial management     :
+         :            :        :                                  :         : decisions.                       :
+         | edpol      |    202 | Technology in the Classroom      |       3 | Theories and practice of using   |
+         :            :        :                                  :         : educational technologies to      :
+         :            :        :                                  :         : support problem-based learning.  :
+         | edpol      |    313 | Technology, Society and Schools  |       3 | Examination of theories and      |
+         :            :        :                                  :         : history of interaction of        :
+         :            :        :                                  :         : society and technology with      :
+         :            :        :                                  :         : implications for instructional   :
+         :            :        :                                  :         : technology and schooling.        :
+         :            :        :                                  :         : Resources for constructing       :
+         :            :        :                                  :         : personal definitions of          :
+         :            :        :                                  :         : technology.                      :
+         | edpol      |    505 | Qualitative Research for         |       3 | This course provides an          |
+         :            :        : Educators                        :         : introduction to qualitative      :
+         :            :        :                                  :         : research at the Master level.    :
+         | edpol      |    551 | Classroom Visit                  |         | Elective visit to a local        |
+         :            :        :                                  :         : classroom for observation.       :
+         | edpol      |    617 | Educational Policy Analysis      |       3 | Frameworks for analyzing,        |
+         :            :        :                                  :         : designing policy proposals, and  :
+         :            :        :                                  :         : implementing plans.              :
+         | ee         |    107 | Exploration of Electrical        |       3 | "Exploration of electrical       |
+         :            :        : Engineering                      :         : engineering through several      :
+         :            :        :                                  :         : hands-on activities that cover a :
+         :            :        :                                  :         : broad spectrum of applications   :
+         :            :        :                                  :         : and fundamental concepts. "      :
+         | ee         |    202 | Engineering Electromagnetics     |       3 | Static electric and magnetic     |
+         :            :        :                                  :         : fields; solutions to static      :
+         :            :        :                                  :         : field problems, electromagnetic  :
+         :            :        :                                  :         : waves, boundary conditions,      :
+         :            :        :                                  :         : engineering applications.        :
+         | ee         |    412 | Laboratory in Electrical         |       4 | Hands-on experience covering     |
+         :            :        : Engineering                      :         : areas of optical transforms,     :
+         :            :        :                                  :         : electro-optics devices, signal   :
+         :            :        :                                  :         : processing, fiber optics         :
+         :            :        :                                  :         : transmission, and holography.    :
+         | ee         |    505 | Information Theory               |       3 | Mathematical measurement of      |
+         :            :        :                                  :         : information; information         :
+         :            :        :                                  :         : transfer in discrete systems;    :
+         :            :        :                                  :         : redundancy, efficiency, and      :
+         :            :        :                                  :         : channel capacity; encoding       :
+         :            :        :                                  :         : systems.                         :
+         | ee         |    615 | Learning and Adaptive Systems    |       3 | Adaptive and learning control    |
+         :            :        :                                  :         : systems; system identification;  :
+         :            :        :                                  :         : performance indices; gradient,   :
+         :            :        :                                  :         : stochastic approximation,        :
+         :            :        :                                  :         : controlled random search         :
+         :            :        :                                  :         : methods; introduction to pattern :
+         :            :        :                                  :         : recognition.                     :
+         | eng        |    101 | Introduction to Composition      |       3 | Provides students with the       |
+         :            :        :                                  :         : fundamental skills to read,      :
+         :            :        :                                  :         : interpret, and write critically  :
+         :            :        :                                  :         : at the college level.            :
+         | eng        |    175 | College Newspaper                |       2 | Students will perform            |
+         :            :        :                                  :         : journalistic writing exercises   :
+         :            :        :                                  :         : for publication in the college   :
+         :            :        :                                  :         : newspaper.                       :
+         | eng        |    247 | Boccaccio's Decameron            |       3 | Follows of the arc of of the     |
+         :            :        :                                  :         : career Boccaccio with an         :
+         :            :        :                                  :         : emphasis on the Decameron, which :
+         :            :        :                                  :         : is read in light of its cultural :
+         :            :        :                                  :         : density and contextualized in    :
+         :            :        :                                  :         : terms of its antecedents,        :
+         :            :        :                                  :         : especially the Commedia of       :
+         :            :        :                                  :         : Dante.                           :
+         | eng        |    276 | Introduction to Science Writing  |       3 | This course provides an          |
+         :            :        :                                  :         : introduction to science writing. :
+         :            :        :                                  :         : Students will learn about the    :
+         :            :        :                                  :         : business of science writing and  :
+         :            :        :                                  :         : will become familiar with the    :
+         :            :        :                                  :         : craft of making complex          :
+         :            :        :                                  :         : scientific research              :
+         :            :        :                                  :         : understandable for the general   :
+         :            :        :                                  :         : public.                          :
+         | eng        |    311 | Writing Styles                   |       3 | This practical course aids in    |
+         :            :        :                                  :         : understanding and writing        :
+         :            :        :                                  :         : non-fiction. We will look at     :
+         :            :        :                                  :         : some of the ways that prominent  :
+         :            :        :                                  :         : English writers have constructed :
+         :            :        :                                  :         : their sentences and paragraphs.  :
+         :            :        :                                  :         : Students will write weekly       :
+         :            :        :                                  :         : exercises exploring these        :
+         :            :        :                                  :         : stylistic patterns.              :
+         | eng        |    412 | Ecology Writing Workshop         |       2 | This monthly workshop will focus |
+         :            :        :                                  :         : on creation of a course          :
+         :            :        :                                  :         : assignment, a feature-length     :
+         :            :        :                                  :         : magazine article covering a      :
+         :            :        :                                  :         : complex topic in ecology.        :
+         | hist       |    112 | The United States in World       |       3 | Examines the meaning of empire   |
+         :            :        : History                          :         : in relationship to the           :
+         :            :        :                                  :         : historical development of the    :
+         :            :        :                                  :         : United States of America.        :
+         | hist       |    212 | Historical Perspective on the    |       3 | This course covers the           |
+         :            :        : Constitution                     :         : development of the               :
+         :            :        :                                  :         : constitutional doctrine from     :
+         :            :        :                                  :         : 1787 to the present. The         :
+         :            :        :                                  :         : Constitution as an experiment in :
+         :            :        :                                  :         : Republicanism.                   :
+         | hist       |    333 | History of American Education    |       3 | A study of informal and formal   |
+         :            :        :                                  :         : education in American history    :
+         :            :        :                                  :         : leading to an understanding of   :
+         :            :        :                                  :         : present educational theory and   :
+         :            :        :                                  :         : practice.                        :
+         | hist       |    415 | History of the Family in Global  |       3 | Has the family really declined?  |
+         :            :        : Perspective                      :         : What has changed in the last     :
+         :            :        :                                  :         : 1000 years? Drawing on           :
+         :            :        :                                  :         : cross-cultural examples,         :
+         :            :        :                                  :         : primarily from Latin America,    :
+         :            :        :                                  :         : the U.S. and Europe, this        :
+         :            :        :                                  :         : seminar explores the varieties   :
+         :            :        :                                  :         : of domestic forms.               :
+         | hist       |    505 | Science and History              |       3 | Introduces students to           |
+         :            :        :                                  :         : approaches and methods in the    :
+         :            :        :                                  :         : history of science, technology,  :
+         :            :        :                                  :         : and medicine                     :
+         | lang       |    201 | Introduction to Spanish          |       4 | Introduction to the Spanish      |
+         :            :        :                                  :         : language, with an emphasis on    :
+         :            :        :                                  :         : every day conversation and basic :
+         :            :        :                                  :         : grammar.                         :
+         | lang       |    203 | Intermediate Spanish             |       3 | Continuation of fundamental      |
+         :            :        :                                  :         : Spanish language learning,       :
+         :            :        :                                  :         : including verb tenses, reading   :
+         :            :        :                                  :         : skills, and basic conversation.  :
+         | lang       |    207 | Child Second Language            |       3 | Examines issues in child second  |
+         :            :        : Development                      :         : language acquisition, including  :
+         :            :        :                                  :         : the critical period hypothesis   :
+         :            :        :                                  :         : and universal grammar.           :
+         | lang       |    304 | Spanish Conversation Group       |       2 | Informal weekly conversation     |
+         :            :        :                                  :         : group designed to improve        :
+         :            :        :                                  :         : understanding of spoken Spanish. :
+         :            :        :                                  :         : Suitable for both majors and     :
+         :            :        :                                  :         : casual speakers who wish to      :
+         :            :        :                                  :         : improve their skills for         :
+         :            :        :                                  :         : personal enjoyment or travel.    :
+         | lang       |    305 | Second Language Syntax           |       3 | This course examines the form    |
+         :            :        :                                  :         : and acquisition of nonnative     :
+         :            :        :                                  :         : syntax. Consideration of whether :
+         :            :        :                                  :         : nonnative grammars are           :
+         :            :        :                                  :         : fundamentally different than     :
+         :            :        :                                  :         : native grammars.                 :
+         | me         |    111 | Introduction to Mechanical       |       3 | Topics include an overview of    |
+         :            :        : Engineering                      :         : career opportunities, problem    :
+         :            :        :                                  :         : solving processes, an            :
+         :            :        :                                  :         : introduction to the basic        :
+         :            :        :                                  :         : engineering design process,      :
+         :            :        :                                  :         : professionalism, professional    :
+         :            :        :                                  :         : registration, and ethics.        :
+         | me         |    344 | Undergraduate Research           |       4 | Undergraduates will conduct      |
+         :            :        :                                  :         : independent research activities  :
+         :            :        :                                  :         : under the direction of their     :
+         :            :        :                                  :         : major adviser.                   :
+         | me         |    501 | Advanced Welding                 |       3 | Advanced applications of welding |
+         :            :        :                                  :         : and machine tool technology.     :
+         :            :        :                                  :         : Computer numerical control,      :
+         :            :        :                                  :         : multi-axis machining set-up, gas :
+         :            :        :                                  :         : tungsten arc welding, and gas    :
+         :            :        :                                  :         : metal arch welding.              :
+         | me         |    627 | Advanced Heating and Air         |       4 | ""                               |
+         :            :        : Conditioning                     :         :                                  :
+         | me         |    712 | Graphic Communication and Design |       3 | Sketching and orthographic       |
+         :            :        :                                  :         : projection. Covers detail and    :
+         :            :        :                                  :         : assembly working drawings,       :
+         :            :        :                                  :         : dimensioning, tolerance          :
+         :            :        :                                  :         : specification, and design        :
+         :            :        :                                  :         : projects.                        :
+         | mth        |    101 | College Algebra                  |       5 | This course, taken mostly by     |
+         :            :        :                                  :         : members from the School of       :
+         :            :        :                                  :         : Business is a primary graduate   :
+         :            :        :                                  :         : student funding vehicle for the  :
+         :            :        :                                  :         : the Department of                :
+         :            :        :                                  :         : Mathematics.  This is a 1000     :
+         :            :        :                                  :         : person lecture reviews basic     :
+         :            :        :                                  :         : concepts taught in high school.  :
+         | phys       |    211 | General Physics I                |       3 | This course deals primarily with |
+         :            :        :                                  :         : motions of objects and the       :
+         :            :        :                                  :         : forces that underlie these       :
+         :            :        :                                  :         : motions, including free fall,    :
+         :            :        :                                  :         : collisions between objects,      :
+         :            :        :                                  :         : rolling, and spinning.           :
+         | phys       |    303 | Relativity & Cosmology           |       3 | The course will describe         |
+         :            :        :                                  :         : developments that led to special :
+         :            :        :                                  :         : relativity and its implications  :
+         :            :        :                                  :         : about the nature of space and    :
+         :            :        :                                  :         : time, as well as general         :
+         :            :        :                                  :         : relativity and quantum           :
+         :            :        :                                  :         : mechanics.                       :
+         | phys       |    388 | Experimental Physics I           |       2 | In this course students will     |
+         :            :        :                                  :         : perform several experiments in   :
+         :            :        :                                  :         : different areas of physics. They :
+         :            :        :                                  :         : will also learn fundamental      :
+         :            :        :                                  :         : experimental techniques and how  :
+         :            :        :                                  :         : to record and report results and :
+         :            :        :                                  :         : perform analysis.                :
+         | phys       |    512 | Quantum Field Theory             |       3 | This course will cover the basic |
+         :            :        :                                  :         : quantization of bosonic and      :
+         :            :        :                                  :         : fermionic fields, discrete       :
+         :            :        :                                  :         : spacetime symmetries,            :
+         :            :        :                                  :         : perturbative methods in QFT,     :
+         :            :        :                                  :         : definition of the S-matrix for   :
+         :            :        :                                  :         : scattering and decay processes.  :
+         | phys       |    713 | Quarks, Nuclei, and Cosmology    |       3 | General topics covered will      |
+         :            :        :                                  :         : include the structure of the     :
+         :            :        :                                  :         : nucleon, beta decay and weak     :
+         :            :        :                                  :         : interactions, and                :
+         :            :        :                                  :         : nucleon-nucleon interaction.     :
+         | phys       |    819 | Superconductivity                |       3 | This course provides a           |
+         :            :        :                                  :         : phenomenological approach to     :
+         :            :        :                                  :         : superconductivity, emphasizing   :
+         :            :        :                                  :         : super-conducting electronics.    :
+         | poli       |    113 | American Government and Politics |       3 | This course examines the         |
+         :            :        :                                  :         : structure, services, functions,  :
+         :            :        :                                  :         : and problems of government and   :
+         :            :        :                                  :         : politics at the national level.  :
+         | poli       |    347 | American Foreign Policy          |       3 | Theories, processes, and problem |
+         :            :        :                                  :         : of American foreign policy and   :
+         :            :        :                                  :         : the craft of diplomacy, with     :
+         :            :        :                                  :         : special attention to             :
+         :            :        :                                  :         : contemporary issues.             :
+         | poli       |    402 | Government Internship: Semester  |       4 | Junior or seniors with a 3.0     |
+         :            :        : in Washington                    :         : grade point average or higher    :
+         :            :        :                                  :         : may apply for a limited number   :
+         :            :        :                                  :         : of internship opportunities in   :
+         :            :        :                                  :         : Washington, DC. Interns will     :
+         :            :        :                                  :         : live at University House on      :
+         :            :        :                                  :         : Capitol Hill and continue their  :
+         :            :        :                                  :         : normal class schedule at the DC  :
+         :            :        :                                  :         : Campus.                          :
+         | poli       |    431 | American Government and          |       3 | This course will examine the     |
+         :            :        : Corporate Interests              :         : methods by which American        :
+         :            :        :                                  :         : business exert influence over    :
+         :            :        :                                  :         : legislators and the legislative  :
+         :            :        :                                  :         : process.                         :
+         | poli       |    644 | Research Seminar in Middle       |       3 | Government and Politics of the   |
+         :            :        : Eastern Affairs                  :         : Middle East and North Africa     :
+         :            :        :                                  :         : Spring. Historical background,   :
+         :            :        :                                  :         : contemporary setting, political  :
+         :            :        :                                  :         : processes, and major problems of :
+         :            :        :                                  :         : some of the countries of Middle  :
+         :            :        :                                  :         : East and North Africa.           :
+         | poli       |    715 | #5 is the 50% Solution           |       3 | A history of the two-state       |
+         :            :        :                                  :         : solution and other approaches to :
+         :            :        :                                  :         : Palestian Statehood              :
+         | psych      |    102 | General Psychology               |       3 | This course introduces the       |
+         :            :        :                                  :         : student to the major topics in   :
+         :            :        :                                  :         : scientific psychology as applied :
+         :            :        :                                  :         : to human behavior. Applications  :
+         :            :        :                                  :         : of these principles will be made :
+         :            :        :                                  :         : to the human experience.         :
+         | psych      |    304 | Introduction to Cognitive        |       3 | An introduction to the basic     |
+         :            :        : Psychology                       :         : concepts of cognitive            :
+         :            :        :                                  :         : psychology, including areas such :
+         :            :        :                                  :         : as perception, attention,        :
+         :            :        :                                  :         : memory, language, and thought.   :
+         | psych      |    450 | Laboratory in Applied Behavioral |       4 | This course will provide         |
+         :            :        : Science                          :         : students with hands-on training  :
+         :            :        :                                  :         : in the application of behavioral :
+         :            :        :                                  :         : research technology to a         :
+         :            :        :                                  :         : clinical population.             :
+         | psych      |    560 | Examination of Real-Time         |       4 | This lab course examines methods |
+         :            :        : Language Processing              :         : for the real-time examination of :
+         :            :        :                                  :         : language processing in normal    :
+         :            :        :                                  :         : and disordered  language         :
+         :            :        :                                  :         : populations.                     :
+         | psych      |    610 | Applied Child Psychology         |       3 | Introduction to major concepts   |
+         :            :        :                                  :         : and models used in psychological :
+         :            :        :                                  :         : assessment and psychotherapeutic :
+         :            :        :                                  :         : intervention of children.        :
+         :            :        :                                  :         : Several modalities of            :
+         :            :        :                                  :         : psychotherapy (individual,       :
+         :            :        :                                  :         : group, and family) will be       :
+         :            :        :                                  :         : reviewed along with research on  :
+         :            :        :                                  :         : their efficacy.                  :
+         | stdart     |    119 | Spring Basket Weaving Workshop   |         | A just-for-fun chance to learn   |
+         :            :        :                                  :         : the basics of basket weaving.    :
+         | stdart     |    333 | Drawing                          |       3 | Exploration of the structure and |
+         :            :        :                                  :         : interrelationships of visual     :
+         :            :        :                                  :         : form in drawing, painting, and   :
+         :            :        :                                  :         : sculpture. Principal historical  :
+         :            :        :                                  :         : modes of drawing are examined.   :
+         | stdart     |    411 | Underwater Basket Weaving        |       4 | This course provides a novel     |
+         :            :        :                                  :         : perspective on the traditional   :
+         :            :        :                                  :         : art of basketry as it is         :
+         :            :        :                                  :         : experienced in reduced gravity   :
+         :            :        :                                  :         : and in the context of fluid      :
+         :            :        :                                  :         : dynamics. Requires instructor    :
+         :            :        :                                  :         : permission and a valid c-card.   :
+         | stdart     |    509 | Twentieth Century Printmaking    |       4 | Development of personalized      |
+         :            :        :                                  :         : concepts and individual          :
+         :            :        :                                  :         : aesthetic expression in          :
+         :            :        :                                  :         : printmaking with reference to    :
+         :            :        :                                  :         : various styles and trends in     :
+         :            :        :                                  :         : Twentieth Century printmaking.   :
+         | stdart     |    512 | Art in Therapy                   |       3 | Surveys methods and results of   |
+         :            :        :                                  :         : using art and craft therapy with :
+         :            :        :                                  :         : developmentally disabled adults. :
+         | stdart     |    614 | Drawing Master Class             |       5 | For fine arts majors only, an    |
+         :            :        :                                  :         : intensive studio study including :
+         :            :        :                                  :         : field trips to local parks and   :
+         :            :        :                                  :         : museums and a final group art    :
+         :            :        :                                  :         : show.                            :
+         | stdart     |    714 | Peer Portfolio Review            |       0 | An opportunity to practice       |
+         :            :        :                                  :         : giving and receiving             :
+         :            :        :                                  :         : constructive criticism.          :
+         | tched      |    122 | Theory and Practice of Early     |       3 | Emphasis on the skills and       |
+         :            :        : Childhood Education              :         : processes needed for the design  :
+         :            :        :                                  :         : and implementation of optimal    :
+         :            :        :                                  :         : learning environments.           :
+         :            :        :                                  :         : Exploration of issues related to :
+         :            :        :                                  :         : societal and cultural influences :
+         :            :        :                                  :         : on the education of young        :
+         :            :        :                                  :         : children.                        :
+         | tched      |    155 | Methods of Early Science         |       3 | A study of the curriculum        |
+         :            :        : Education                        :         : methods, concepts, techniques,   :
+         :            :        :                                  :         : and materials in the teaching of :
+         :            :        :                                  :         : general science to children in   :
+         :            :        :                                  :         : the early grades.                :
+         | tched      |    367 | Problems in Education Management |       3 | This course is designed to       |
+         :            :        :                                  :         : assist the student to prepare    :
+         :            :        :                                  :         : for management of educational    :
+         :            :        :                                  :         : organizations and programs.      :
+         :            :        :                                  :         : Emphasis will be placed upon     :
+         :            :        :                                  :         : identifying specific problems    :
+         :            :        :                                  :         : and developing specific          :
+         :            :        :                                  :         : techniques by which to solve     :
+         :            :        :                                  :         : them.                            :
+         | tched      |    501 | Challenges of Teaching the       |       3 | The nature and needs of the      |
+         :            :        : Gifted and Talented              :         : talented and gifted in all areas :
+         :            :        :                                  :         : of development are explored.     :
+         | tched      |    609 | Supervised Internship in         |       4 | Supervised Internship I provides |
+         :            :        : Education                        :         : on-site, supervised              :
+         :            :        :                                  :         : instructional experience within  :
+         :            :        :                                  :         : a public school setting under    :
+         :            :        :                                  :         : the leadership of an             :
+         :            :        :                                  :         : appropriate, competent           :
+         :            :        :                                  :         : professional.                    :
+                                                                                                       (99 rows)
+
+         ----
+         /course?title!='Organic Chemistry Laboratory I'
+         SELECT "course"."department", "course"."number", "course"."title", "course"."credits", "course"."description" FROM "ad"."course" AS "course" WHERE ("course"."title" != 'Organic Chemistry Laboratory I') ORDER BY 1 ASC, 2 ASC
+    - uri: /course{department,number,title}?number=101
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?number=101)                               |
+        -+---------------------------------------------------+-
+         | department | number | title                       |
+        -+------------+--------+-----------------------------+-
+         | eng        |    101 | Introduction to Composition |
+         | mth        |    101 | College Algebra             |
+                                                      (2 rows)
+
+         ----
+         /course{department,number,title}?number=101
+         SELECT "course"."department", "course"."number", "course"."title" FROM "ad"."course" AS "course" WHERE ("course"."number" = 101) ORDER BY 1 ASC, 2 ASC
+    - uri: /course?credits>3
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?credits>3)                                                                                  |
+        -+-----------------------------------------------------------------------------------------------------+-
+         | department | number | title                            | credits | description                      |
+        -+------------+--------+----------------------------------+---------+----------------------------------+-
+         | acc        |    315 | Financial Accounting             |       5 | Integration of the conceptual    |
+         :            :        :                                  :         : and computational aspects of     :
+         :            :        :                                  :         : asset, liability and             :
+         :            :        :                                  :         : stockholders equity accounting.  :
+         | arthis     |    712 | Museum and Gallery Management    |       4 | Supervised independent field     |
+         :            :        :                                  :         : experience and practical work in :
+         :            :        :                                  :         : all areas of Art Museum          :
+         :            :        :                                  :         : management in the university and :
+         :            :        :                                  :         : greater metropolitan area        :
+         :            :        :                                  :         : communities.                     :
+         | be         |    415 | Internship in Biomedical         |       8 | The student will work twenty     |
+         :            :        : Engineering                      :         : hours per week in an area firm   :
+         :            :        :                                  :         : to gain experience in the        :
+         :            :        :                                  :         : application of biomedical        :
+         :            :        :                                  :         : engineering principles in an     :
+         :            :        :                                  :         : industrial setting.              :
+         | comp       |    710 | Laboratory in Computer Science   |       4 | Independent research opportunity |
+         :            :        :                                  :         : using the university computer    :
+         :            :        :                                  :         : lab. Requires instructor         :
+         :            :        :                                  :         : permission and may be repeated.  :
+         | ee         |    412 | Laboratory in Electrical         |       4 | Hands-on experience covering     |
+         :            :        : Engineering                      :         : areas of optical transforms,     :
+         :            :        :                                  :         : electro-optics devices, signal   :
+         :            :        :                                  :         : processing, fiber optics         :
+         :            :        :                                  :         : transmission, and holography.    :
+         | lang       |    201 | Introduction to Spanish          |       4 | Introduction to the Spanish      |
+         :            :        :                                  :         : language, with an emphasis on    :
+         :            :        :                                  :         : every day conversation and basic :
+         :            :        :                                  :         : grammar.                         :
+         | me         |    344 | Undergraduate Research           |       4 | Undergraduates will conduct      |
+         :            :        :                                  :         : independent research activities  :
+         :            :        :                                  :         : under the direction of their     :
+         :            :        :                                  :         : major adviser.                   :
+         | me         |    627 | Advanced Heating and Air         |       4 | ""                               |
+         :            :        : Conditioning                     :         :                                  :
+         | mth        |    101 | College Algebra                  |       5 | This course, taken mostly by     |
+         :            :        :                                  :         : members from the School of       :
+         :            :        :                                  :         : Business is a primary graduate   :
+         :            :        :                                  :         : student funding vehicle for the  :
+         :            :        :                                  :         : the Department of                :
+         :            :        :                                  :         : Mathematics.  This is a 1000     :
+         :            :        :                                  :         : person lecture reviews basic     :
+         :            :        :                                  :         : concepts taught in high school.  :
+         | poli       |    402 | Government Internship: Semester  |       4 | Junior or seniors with a 3.0     |
+         :            :        : in Washington                    :         : grade point average or higher    :
+         :            :        :                                  :         : may apply for a limited number   :
+         :            :        :                                  :         : of internship opportunities in   :
+         :            :        :                                  :         : Washington, DC. Interns will     :
+         :            :        :                                  :         : live at University House on      :
+         :            :        :                                  :         : Capitol Hill and continue their  :
+         :            :        :                                  :         : normal class schedule at the DC  :
+         :            :        :                                  :         : Campus.                          :
+         | psych      |    450 | Laboratory in Applied Behavioral |       4 | This course will provide         |
+         :            :        : Science                          :         : students with hands-on training  :
+         :            :        :                                  :         : in the application of behavioral :
+         :            :        :                                  :         : research technology to a         :
+         :            :        :                                  :         : clinical population.             :
+         | psych      |    560 | Examination of Real-Time         |       4 | This lab course examines methods |
+         :            :        : Language Processing              :         : for the real-time examination of :
+         :            :        :                                  :         : language processing in normal    :
+         :            :        :                                  :         : and disordered  language         :
+         :            :        :                                  :         : populations.                     :
+         | stdart     |    411 | Underwater Basket Weaving        |       4 | This course provides a novel     |
+         :            :        :                                  :         : perspective on the traditional   :
+         :            :        :                                  :         : art of basketry as it is         :
+         :            :        :                                  :         : experienced in reduced gravity   :
+         :            :        :                                  :         : and in the context of fluid      :
+         :            :        :                                  :         : dynamics. Requires instructor    :
+         :            :        :                                  :         : permission and a valid c-card.   :
+         | stdart     |    509 | Twentieth Century Printmaking    |       4 | Development of personalized      |
+         :            :        :                                  :         : concepts and individual          :
+         :            :        :                                  :         : aesthetic expression in          :
+         :            :        :                                  :         : printmaking with reference to    :
+         :            :        :                                  :         : various styles and trends in     :
+         :            :        :                                  :         : Twentieth Century printmaking.   :
+         | stdart     |    614 | Drawing Master Class             |       5 | For fine arts majors only, an    |
+         :            :        :                                  :         : intensive studio study including :
+         :            :        :                                  :         : field trips to local parks and   :
+         :            :        :                                  :         : museums and a final group art    :
+         :            :        :                                  :         : show.                            :
+         | tched      |    609 | Supervised Internship in         |       4 | Supervised Internship I provides |
+         :            :        : Education                        :         : on-site, supervised              :
+         :            :        :                                  :         : instructional experience within  :
+         :            :        :                                  :         : a public school setting under    :
+         :            :        :                                  :         : the leadership of an             :
+         :            :        :                                  :         : appropriate, competent           :
+         :            :        :                                  :         : professional.                    :
+                                                                                                       (16 rows)
+
+         ----
+         /course?credits>3
+         SELECT "course"."department", "course"."number", "course"."title", "course"."credits", "course"."description" FROM "ad"."course" AS "course" WHERE ("course"."credits" > 3) ORDER BY 1 ASC, 2 ASC
+    - uri: /course?credits>=3
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?credits>=3)                                                                                 |
+        -+-----------------------------------------------------------------------------------------------------+-
+         | department | number | title                            | credits | description                      |
+        -+------------+--------+----------------------------------+---------+----------------------------------+-
+         | acc        |    200 | Principles of Accounting I       |       3 | The initial course in the theory |
+         :            :        :                                  :         : and practice of financial        :
+         :            :        :                                  :         : accounting. Topics emphasized    :
+         :            :        :                                  :         : include the preparation,         :
+         :            :        :                                  :         : reporting, and analysis of       :
+         :            :        :                                  :         : financial data.                  :
+         | acc        |    315 | Financial Accounting             |       5 | Integration of the conceptual    |
+         :            :        :                                  :         : and computational aspects of     :
+         :            :        :                                  :         : asset, liability and             :
+         :            :        :                                  :         : stockholders equity accounting.  :
+         | acc        |    426 | Corporate Taxation               |       3 | Concepts and methods of          |
+         :            :        :                                  :         : determining federal tax          :
+         :            :        :                                  :         : liability of corporations.       :
+         | acc        |    527 | Advanced Accounting              |       3 | Theory and practical             |
+         :            :        :                                  :         : applications of accounting for   :
+         :            :        :                                  :         : consolidated entities and        :
+         :            :        :                                  :         : partnerships; includes foreign   :
+         :            :        :                                  :         : currency transactions, hedging   :
+         :            :        :                                  :         : and derivatives.                 :
+         | acc        |    606 | Corporate Financial Law          |       3 | Law governing business           |
+         :            :        :                                  :         : corporations; fiduciary duties   :
+         :            :        :                                  :         : of managers and directors in     :
+         :            :        :                                  :         : situations such as mergers,      :
+         :            :        :                                  :         : acquisitions, securities         :
+         :            :        :                                  :         : offerings, market domination,    :
+         :            :        :                                  :         : litigation.                      :
+         | arthis     |    202 | History of Art Criticism         |       3 | An introductory survey course on |
+         :            :        :                                  :         : Prehistoric through              :
+         :            :        :                                  :         : late-Medieval art history.       :
+         | arthis     |    340 | Arts of Asia                     |       3 | An introduction to the history   |
+         :            :        :                                  :         : and criticism of Far Eastern     :
+         :            :        :                                  :         : art, including the art of China  :
+         :            :        :                                  :         : and Japan, fine and decorative   :
+         :            :        :                                  :         : arts.                            :
+         | arthis     |    623 | Contemporary Latin American Art  |       3 | A survey of the last twenty      |
+         :            :        :                                  :         : years of Latin American art with :
+         :            :        :                                  :         : a focus on the Caribbean and     :
+         :            :        :                                  :         : Central America.                 :
+         | arthis     |    710 | Methods in Art History           |       3 | This seminar focuses on basic    |
+         :            :        :                                  :         : types of art-historical method.  :
+         :            :        :                                  :         : Some meetings focus on a single  :
+         :            :        :                                  :         : author who exemplifies a         :
+         :            :        :                                  :         : particular approach.             :
+         | arthis     |    712 | Museum and Gallery Management    |       4 | Supervised independent field     |
+         :            :        :                                  :         : experience and practical work in :
+         :            :        :                                  :         : all areas of Art Museum          :
+         :            :        :                                  :         : management in the university and :
+         :            :        :                                  :         : greater metropolitan area        :
+         :            :        :                                  :         : communities.                     :
+         | arthis     |    809 | Materials and Construction in    |       3 | A scientific examination of the  |
+         :            :        : European Art                     :         : materials and manufacturing      :
+         :            :        :                                  :         : techniques employed in Europe    :
+         :            :        :                                  :         : over the last two centuries.     :
+         | astro      |    137 | The Solar System                 |       3 | Introductory survey of the solar |
+         :            :        :                                  :         : system, including structure and  :
+         :            :        :                                  :         : motion of the planets,           :
+         :            :        :                                  :         : properties of the sun, and       :
+         :            :        :                                  :         : comparison to extrasolar         :
+         :            :        :                                  :         : systems.                         :
+         | astro      |    254 | Life in the Universe             |       3 | Nature and origin of large       |
+         :            :        :                                  :         : numbers in the cosmos, the       :
+         :            :        :                                  :         : formation of planets, formation  :
+         :            :        :                                  :         : of life, and the anthropic       :
+         :            :        :                                  :         : principle.                       :
+         | be         |    112 | Introduction to Biomedical       |       3 | This course covers topics in     |
+         :            :        : Engineering                      :         : multiple formats ranging from    :
+         :            :        :                                  :         : lectures by faculty or guest     :
+         :            :        :                                  :         : speakers to presentations by     :
+         :            :        :                                  :         : participating students.          :
+         | be         |    308 | Fundamentals of Biochemistry     |       3 | Fundamental aspects of human     |
+         :            :        :                                  :         : biochemistry are introduced in   :
+         :            :        :                                  :         : this course for students in the  :
+         :            :        :                                  :         : bioinstrumentation/biosensors,   :
+         :            :        :                                  :         : biomechanics, and                :
+         :            :        :                                  :         : medical-imaging tracks.          :
+         | be         |    415 | Internship in Biomedical         |       8 | The student will work twenty     |
+         :            :        : Engineering                      :         : hours per week in an area firm   :
+         :            :        :                                  :         : to gain experience in the        :
+         :            :        :                                  :         : application of biomedical        :
+         :            :        :                                  :         : engineering principles in an     :
+         :            :        :                                  :         : industrial setting.              :
+         | be         |    509 | Systems of Drug Delivery         |       3 | The mathematics of diffusion     |
+         :            :        :                                  :         : through various types of         :
+         :            :        :                                  :         : biological media is discussed.   :
+         | capmrk     |    712 | International Financial Markets  |       3 | Offers an understanding of the   |
+         :            :        :                                  :         : international financial          :
+         :            :        :                                  :         : structure and studies its impact :
+         :            :        :                                  :         : on business and individuals in   :
+         :            :        :                                  :         : various nations.                 :
+         | capmrk     |    756 | Capital Risk Management          |       3 | This course introduces           |
+         :            :        :                                  :         : fundamental principles and       :
+         :            :        :                                  :         : techniques of financial risk     :
+         :            :        :                                  :         : management.                      :
+         | capmrk     |    808 | Principles of Portfolio          |       3 | Comprehensive coverage of the    |
+         :            :        : Management                       :         : theory and practice of money     :
+         :            :        :                                  :         : management as well as in-depth   :
+         :            :        :                                  :         : analysis of the theory and       :
+         :            :        :                                  :         : practice involved when           :
+         :            :        :                                  :         : securities are combined into     :
+         :            :        :                                  :         : portfolios.                      :
+         | capmrk     |    818 | Financial Statement Analysis     |       3 | This course presents techniques  |
+         :            :        :                                  :         : for analyzing current and        :
+         :            :        :                                  :         : projected financial statements   :
+         :            :        :                                  :         : for the purposes of credit       :
+         :            :        :                                  :         : analysis, security analysis, and :
+         :            :        :                                  :         : internal financial analysis, and :
+         :            :        :                                  :         : cash flow forecasting.           :
+         | chem       |    100 | Principles of Chemistry          |       3 | This course offers an            |
+         :            :        :                                  :         : introduction to the biological,  :
+         :            :        :                                  :         : inorganic, and chemical          :
+         :            :        :                                  :         : molecules, with an emphasis on   :
+         :            :        :                                  :         : basic principles of atomic and   :
+         :            :        :                                  :         : molecular electronic structure.  :
+         | chem       |    110 | Organic Chemistry I              |       3 | This course offers a practical   |
+         :            :        :                                  :         : introduction to organic          :
+         :            :        :                                  :         : chemistry, including a full set  :
+         :            :        :                                  :         : of problem sets with solutions.  :
+         :            :        :                                  :         : Focus is on the basic principles :
+         :            :        :                                  :         : of understanding the structure   :
+         :            :        :                                  :         : and reactivity of organic        :
+         :            :        :                                  :         : molecules.                       :
+         | chem       |    314 | Laboratory Chemistry             |       3 | Experimental chemistry for       |
+         :            :        :                                  :         : students who are planning to     :
+         :            :        :                                  :         : major in chemistry. Covers       :
+         :            :        :                                  :         : principles and applications of   :
+         :            :        :                                  :         : chemical laboratory techniques,  :
+         :            :        :                                  :         : including preparation and        :
+         :            :        :                                  :         : analysis of chemical materials.  :
+         | chem       |    655 | Protein Folding Problem          |       3 | Focuses on the mechanisms        |
+         :            :        :                                  :         : through which the amino acid     :
+         :            :        :                                  :         : sequence of polypeptide chains   :
+         :            :        :                                  :         : determine their                  :
+         :            :        :                                  :         : three-dimensional conformation.  :
+         | comp       |    102 | Introduction to Computer Science |       3 | This course in an introduction   |
+         :            :        :                                  :         : to the discipline of computer    :
+         :            :        :                                  :         : science. Topics include          :
+         :            :        :                                  :         : algorithmic foundations,         :
+         :            :        :                                  :         : hardware concepts, virtual       :
+         :            :        :                                  :         : machine concepts, software       :
+         :            :        :                                  :         : systems, applications, and       :
+         :            :        :                                  :         : social issues.                   :
+         | comp       |    230 | History of Computing             |       3 | This course will survey the      |
+         :            :        :                                  :         : history of the computing field   :
+         :            :        :                                  :         : from antiquity to the present,   :
+         :            :        :                                  :         : focusing on the era of the       :
+         :            :        :                                  :         : electronic digital computer.     :
+         :            :        :                                  :         : Topics will include historical   :
+         :            :        :                                  :         : developments in hardware,        :
+         :            :        :                                  :         : software, and the theoretical    :
+         :            :        :                                  :         : foundations of computer science. :
+         | comp       |    350 | Introduction to Signal           |       3 | This course covers the nature of |
+         :            :        : Processing                       :         : information, signals,            :
+         :            :        :                                  :         : transforms, and applications.    :
+         :            :        :                                  :         : Topics include analog to digital :
+         :            :        :                                  :         : and digital to analog            :
+         :            :        :                                  :         : conversion, data storage (such   :
+         :            :        :                                  :         : as the audio format MP3), data   :
+         :            :        :                                  :         : transforms, and filters.         :
+         | comp       |    615 | Introduction to Automata         |       3 | Theory of computing devices and  |
+         :            :        :                                  :         : the languages they recognize.    :
+         | comp       |    710 | Laboratory in Computer Science   |       4 | Independent research opportunity |
+         :            :        :                                  :         : using the university computer    :
+         :            :        :                                  :         : lab. Requires instructor         :
+         :            :        :                                  :         : permission and may be repeated.  :
+         | comp       |    810 | Thesis Research                  |       3 | Guided research leading to       |
+         :            :        :                                  :         : production of the thesis.        :
+         :            :        :                                  :         : Requires instructor permission   :
+         :            :        :                                  :         : and may be repeated.             :
+         | comp       |    819 | Advanced Algorithms in           |       3 | This course is focused on        |
+         :            :        : Bioinformatics                   :         : fundamental algorithmic          :
+         :            :        :                                  :         : techniques in Bioinformatics,    :
+         :            :        :                                  :         : including classed methods such   :
+         :            :        :                                  :         : as dynamic programming, support  :
+         :            :        :                                  :         : vector machines and other        :
+         :            :        :                                  :         : statistical and learning         :
+         :            :        :                                  :         : optimization methods.            :
+         | corpfi     |    234 | Accounting Information Systems   |       3 | This course bridges the gap      |
+         :            :        :                                  :         : between two disciplines critical :
+         :            :        :                                  :         : to business operations.  This    :
+         :            :        :                                  :         : course of study teaches students :
+         :            :        :                                  :         : to design and deploy information :
+         :            :        :                                  :         : technology to improve the        :
+         :            :        :                                  :         : accounting systems of an         :
+         :            :        :                                  :         : organization.                    :
+         | corpfi     |    404 | Corporate Financial Management   |       3 | This course covers advanced      |
+         :            :        :                                  :         : topics in corporate financial    :
+         :            :        :                                  :         : management, including its role   :
+         :            :        :                                  :         : in corporate governance.         :
+         | corpfi     |    601 | Case Studies in Corporate        |       3 | A course designed to use case    |
+         :            :        : Finance                          :         : studies and financial analysis   :
+         :            :        :                                  :         : to further knowledge and ability :
+         :            :        :                                  :         : to make financial management     :
+         :            :        :                                  :         : decisions.                       :
+         | edpol      |    202 | Technology in the Classroom      |       3 | Theories and practice of using   |
+         :            :        :                                  :         : educational technologies to      :
+         :            :        :                                  :         : support problem-based learning.  :
+         | edpol      |    313 | Technology, Society and Schools  |       3 | Examination of theories and      |
+         :            :        :                                  :         : history of interaction of        :
+         :            :        :                                  :         : society and technology with      :
+         :            :        :                                  :         : implications for instructional   :
+         :            :        :                                  :         : technology and schooling.        :
+         :            :        :                                  :         : Resources for constructing       :
+         :            :        :                                  :         : personal definitions of          :
+         :            :        :                                  :         : technology.                      :
+         | edpol      |    505 | Qualitative Research for         |       3 | This course provides an          |
+         :            :        : Educators                        :         : introduction to qualitative      :
+         :            :        :                                  :         : research at the Master level.    :
+         | edpol      |    617 | Educational Policy Analysis      |       3 | Frameworks for analyzing,        |
+         :            :        :                                  :         : designing policy proposals, and  :
+         :            :        :                                  :         : implementing plans.              :
+         | ee         |    107 | Exploration of Electrical        |       3 | "Exploration of electrical       |
+         :            :        : Engineering                      :         : engineering through several      :
+         :            :        :                                  :         : hands-on activities that cover a :
+         :            :        :                                  :         : broad spectrum of applications   :
+         :            :        :                                  :         : and fundamental concepts. "      :
+         | ee         |    202 | Engineering Electromagnetics     |       3 | Static electric and magnetic     |
+         :            :        :                                  :         : fields; solutions to static      :
+         :            :        :                                  :         : field problems, electromagnetic  :
+         :            :        :                                  :         : waves, boundary conditions,      :
+         :            :        :                                  :         : engineering applications.        :
+         | ee         |    412 | Laboratory in Electrical         |       4 | Hands-on experience covering     |
+         :            :        : Engineering                      :         : areas of optical transforms,     :
+         :            :        :                                  :         : electro-optics devices, signal   :
+         :            :        :                                  :         : processing, fiber optics         :
+         :            :        :                                  :         : transmission, and holography.    :
+         | ee         |    505 | Information Theory               |       3 | Mathematical measurement of      |
+         :            :        :                                  :         : information; information         :
+         :            :        :                                  :         : transfer in discrete systems;    :
+         :            :        :                                  :         : redundancy, efficiency, and      :
+         :            :        :                                  :         : channel capacity; encoding       :
+         :            :        :                                  :         : systems.                         :
+         | ee         |    615 | Learning and Adaptive Systems    |       3 | Adaptive and learning control    |
+         :            :        :                                  :         : systems; system identification;  :
+         :            :        :                                  :         : performance indices; gradient,   :
+         :            :        :                                  :         : stochastic approximation,        :
+         :            :        :                                  :         : controlled random search         :
+         :            :        :                                  :         : methods; introduction to pattern :
+         :            :        :                                  :         : recognition.                     :
+         | eng        |    101 | Introduction to Composition      |       3 | Provides students with the       |
+         :            :        :                                  :         : fundamental skills to read,      :
+         :            :        :                                  :         : interpret, and write critically  :
+         :            :        :                                  :         : at the college level.            :
+         | eng        |    247 | Boccaccio's Decameron            |       3 | Follows of the arc of of the     |
+         :            :        :                                  :         : career Boccaccio with an         :
+         :            :        :                                  :         : emphasis on the Decameron, which :
+         :            :        :                                  :         : is read in light of its cultural :
+         :            :        :                                  :         : density and contextualized in    :
+         :            :        :                                  :         : terms of its antecedents,        :
+         :            :        :                                  :         : especially the Commedia of       :
+         :            :        :                                  :         : Dante.                           :
+         | eng        |    276 | Introduction to Science Writing  |       3 | This course provides an          |
+         :            :        :                                  :         : introduction to science writing. :
+         :            :        :                                  :         : Students will learn about the    :
+         :            :        :                                  :         : business of science writing and  :
+         :            :        :                                  :         : will become familiar with the    :
+         :            :        :                                  :         : craft of making complex          :
+         :            :        :                                  :         : scientific research              :
+         :            :        :                                  :         : understandable for the general   :
+         :            :        :                                  :         : public.                          :
+         | eng        |    311 | Writing Styles                   |       3 | This practical course aids in    |
+         :            :        :                                  :         : understanding and writing        :
+         :            :        :                                  :         : non-fiction. We will look at     :
+         :            :        :                                  :         : some of the ways that prominent  :
+         :            :        :                                  :         : English writers have constructed :
+         :            :        :                                  :         : their sentences and paragraphs.  :
+         :            :        :                                  :         : Students will write weekly       :
+         :            :        :                                  :         : exercises exploring these        :
+         :            :        :                                  :         : stylistic patterns.              :
+         | hist       |    112 | The United States in World       |       3 | Examines the meaning of empire   |
+         :            :        : History                          :         : in relationship to the           :
+         :            :        :                                  :         : historical development of the    :
+         :            :        :                                  :         : United States of America.        :
+         | hist       |    212 | Historical Perspective on the    |       3 | This course covers the           |
+         :            :        : Constitution                     :         : development of the               :
+         :            :        :                                  :         : constitutional doctrine from     :
+         :            :        :                                  :         : 1787 to the present. The         :
+         :            :        :                                  :         : Constitution as an experiment in :
+         :            :        :                                  :         : Republicanism.                   :
+         | hist       |    333 | History of American Education    |       3 | A study of informal and formal   |
+         :            :        :                                  :         : education in American history    :
+         :            :        :                                  :         : leading to an understanding of   :
+         :            :        :                                  :         : present educational theory and   :
+         :            :        :                                  :         : practice.                        :
+         | hist       |    415 | History of the Family in Global  |       3 | Has the family really declined?  |
+         :            :        : Perspective                      :         : What has changed in the last     :
+         :            :        :                                  :         : 1000 years? Drawing on           :
+         :            :        :                                  :         : cross-cultural examples,         :
+         :            :        :                                  :         : primarily from Latin America,    :
+         :            :        :                                  :         : the U.S. and Europe, this        :
+         :            :        :                                  :         : seminar explores the varieties   :
+         :            :        :                                  :         : of domestic forms.               :
+         | hist       |    505 | Science and History              |       3 | Introduces students to           |
+         :            :        :                                  :         : approaches and methods in the    :
+         :            :        :                                  :         : history of science, technology,  :
+         :            :        :                                  :         : and medicine                     :
+         | lang       |    201 | Introduction to Spanish          |       4 | Introduction to the Spanish      |
+         :            :        :                                  :         : language, with an emphasis on    :
+         :            :        :                                  :         : every day conversation and basic :
+         :            :        :                                  :         : grammar.                         :
+         | lang       |    203 | Intermediate Spanish             |       3 | Continuation of fundamental      |
+         :            :        :                                  :         : Spanish language learning,       :
+         :            :        :                                  :         : including verb tenses, reading   :
+         :            :        :                                  :         : skills, and basic conversation.  :
+         | lang       |    207 | Child Second Language            |       3 | Examines issues in child second  |
+         :            :        : Development                      :         : language acquisition, including  :
+         :            :        :                                  :         : the critical period hypothesis   :
+         :            :        :                                  :         : and universal grammar.           :
+         | lang       |    305 | Second Language Syntax           |       3 | This course examines the form    |
+         :            :        :                                  :         : and acquisition of nonnative     :
+         :            :        :                                  :         : syntax. Consideration of whether :
+         :            :        :                                  :         : nonnative grammars are           :
+         :            :        :                                  :         : fundamentally different than     :
+         :            :        :                                  :         : native grammars.                 :
+         | me         |    111 | Introduction to Mechanical       |       3 | Topics include an overview of    |
+         :            :        : Engineering                      :         : career opportunities, problem    :
+         :            :        :                                  :         : solving processes, an            :
+         :            :        :                                  :         : introduction to the basic        :
+         :            :        :                                  :         : engineering design process,      :
+         :            :        :                                  :         : professionalism, professional    :
+         :            :        :                                  :         : registration, and ethics.        :
+         | me         |    344 | Undergraduate Research           |       4 | Undergraduates will conduct      |
+         :            :        :                                  :         : independent research activities  :
+         :            :        :                                  :         : under the direction of their     :
+         :            :        :                                  :         : major adviser.                   :
+         | me         |    501 | Advanced Welding                 |       3 | Advanced applications of welding |
+         :            :        :                                  :         : and machine tool technology.     :
+         :            :        :                                  :         : Computer numerical control,      :
+         :            :        :                                  :         : multi-axis machining set-up, gas :
+         :            :        :                                  :         : tungsten arc welding, and gas    :
+         :            :        :                                  :         : metal arch welding.              :
+         | me         |    627 | Advanced Heating and Air         |       4 | ""                               |
+         :            :        : Conditioning                     :         :                                  :
+         | me         |    712 | Graphic Communication and Design |       3 | Sketching and orthographic       |
+         :            :        :                                  :         : projection. Covers detail and    :
+         :            :        :                                  :         : assembly working drawings,       :
+         :            :        :                                  :         : dimensioning, tolerance          :
+         :            :        :                                  :         : specification, and design        :
+         :            :        :                                  :         : projects.                        :
+         | mth        |    101 | College Algebra                  |       5 | This course, taken mostly by     |
+         :            :        :                                  :         : members from the School of       :
+         :            :        :                                  :         : Business is a primary graduate   :
+         :            :        :                                  :         : student funding vehicle for the  :
+         :            :        :                                  :         : the Department of                :
+         :            :        :                                  :         : Mathematics.  This is a 1000     :
+         :            :        :                                  :         : person lecture reviews basic     :
+         :            :        :                                  :         : concepts taught in high school.  :
+         | phys       |    211 | General Physics I                |       3 | This course deals primarily with |
+         :            :        :                                  :         : motions of objects and the       :
+         :            :        :                                  :         : forces that underlie these       :
+         :            :        :                                  :         : motions, including free fall,    :
+         :            :        :                                  :         : collisions between objects,      :
+         :            :        :                                  :         : rolling, and spinning.           :
+         | phys       |    303 | Relativity & Cosmology           |       3 | The course will describe         |
+         :            :        :                                  :         : developments that led to special :
+         :            :        :                                  :         : relativity and its implications  :
+         :            :        :                                  :         : about the nature of space and    :
+         :            :        :                                  :         : time, as well as general         :
+         :            :        :                                  :         : relativity and quantum           :
+         :            :        :                                  :         : mechanics.                       :
+         | phys       |    512 | Quantum Field Theory             |       3 | This course will cover the basic |
+         :            :        :                                  :         : quantization of bosonic and      :
+         :            :        :                                  :         : fermionic fields, discrete       :
+         :            :        :                                  :         : spacetime symmetries,            :
+         :            :        :                                  :         : perturbative methods in QFT,     :
+         :            :        :                                  :         : definition of the S-matrix for   :
+         :            :        :                                  :         : scattering and decay processes.  :
+         | phys       |    713 | Quarks, Nuclei, and Cosmology    |       3 | General topics covered will      |
+         :            :        :                                  :         : include the structure of the     :
+         :            :        :                                  :         : nucleon, beta decay and weak     :
+         :            :        :                                  :         : interactions, and                :
+         :            :        :                                  :         : nucleon-nucleon interaction.     :
+         | phys       |    819 | Superconductivity                |       3 | This course provides a           |
+         :            :        :                                  :         : phenomenological approach to     :
+         :            :        :                                  :         : superconductivity, emphasizing   :
+         :            :        :                                  :         : super-conducting electronics.    :
+         | poli       |    113 | American Government and Politics |       3 | This course examines the         |
+         :            :        :                                  :         : structure, services, functions,  :
+         :            :        :                                  :         : and problems of government and   :
+         :            :        :                                  :         : politics at the national level.  :
+         | poli       |    347 | American Foreign Policy          |       3 | Theories, processes, and problem |
+         :            :        :                                  :         : of American foreign policy and   :
+         :            :        :                                  :         : the craft of diplomacy, with     :
+         :            :        :                                  :         : special attention to             :
+         :            :        :                                  :         : contemporary issues.             :
+         | poli       |    402 | Government Internship: Semester  |       4 | Junior or seniors with a 3.0     |
+         :            :        : in Washington                    :         : grade point average or higher    :
+         :            :        :                                  :         : may apply for a limited number   :
+         :            :        :                                  :         : of internship opportunities in   :
+         :            :        :                                  :         : Washington, DC. Interns will     :
+         :            :        :                                  :         : live at University House on      :
+         :            :        :                                  :         : Capitol Hill and continue their  :
+         :            :        :                                  :         : normal class schedule at the DC  :
+         :            :        :                                  :         : Campus.                          :
+         | poli       |    431 | American Government and          |       3 | This course will examine the     |
+         :            :        : Corporate Interests              :         : methods by which American        :
+         :            :        :                                  :         : business exert influence over    :
+         :            :        :                                  :         : legislators and the legislative  :
+         :            :        :                                  :         : process.                         :
+         | poli       |    644 | Research Seminar in Middle       |       3 | Government and Politics of the   |
+         :            :        : Eastern Affairs                  :         : Middle East and North Africa     :
+         :            :        :                                  :         : Spring. Historical background,   :
+         :            :        :                                  :         : contemporary setting, political  :
+         :            :        :                                  :         : processes, and major problems of :
+         :            :        :                                  :         : some of the countries of Middle  :
+         :            :        :                                  :         : East and North Africa.           :
+         | poli       |    715 | #5 is the 50% Solution           |       3 | A history of the two-state       |
+         :            :        :                                  :         : solution and other approaches to :
+         :            :        :                                  :         : Palestian Statehood              :
+         | psych      |    102 | General Psychology               |       3 | This course introduces the       |
+         :            :        :                                  :         : student to the major topics in   :
+         :            :        :                                  :         : scientific psychology as applied :
+         :            :        :                                  :         : to human behavior. Applications  :
+         :            :        :                                  :         : of these principles will be made :
+         :            :        :                                  :         : to the human experience.         :
+         | psych      |    304 | Introduction to Cognitive        |       3 | An introduction to the basic     |
+         :            :        : Psychology                       :         : concepts of cognitive            :
+         :            :        :                                  :         : psychology, including areas such :
+         :            :        :                                  :         : as perception, attention,        :
+         :            :        :                                  :         : memory, language, and thought.   :
+         | psych      |    450 | Laboratory in Applied Behavioral |       4 | This course will provide         |
+         :            :        : Science                          :         : students with hands-on training  :
+         :            :        :                                  :         : in the application of behavioral :
+         :            :        :                                  :         : research technology to a         :
+         :            :        :                                  :         : clinical population.             :
+         | psych      |    560 | Examination of Real-Time         |       4 | This lab course examines methods |
+         :            :        : Language Processing              :         : for the real-time examination of :
+         :            :        :                                  :         : language processing in normal    :
+         :            :        :                                  :         : and disordered  language         :
+         :            :        :                                  :         : populations.                     :
+         | psych      |    610 | Applied Child Psychology         |       3 | Introduction to major concepts   |
+         :            :        :                                  :         : and models used in psychological :
+         :            :        :                                  :         : assessment and psychotherapeutic :
+         :            :        :                                  :         : intervention of children.        :
+         :            :        :                                  :         : Several modalities of            :
+         :            :        :                                  :         : psychotherapy (individual,       :
+         :            :        :                                  :         : group, and family) will be       :
+         :            :        :                                  :         : reviewed along with research on  :
+         :            :        :                                  :         : their efficacy.                  :
+         | stdart     |    333 | Drawing                          |       3 | Exploration of the structure and |
+         :            :        :                                  :         : interrelationships of visual     :
+         :            :        :                                  :         : form in drawing, painting, and   :
+         :            :        :                                  :         : sculpture. Principal historical  :
+         :            :        :                                  :         : modes of drawing are examined.   :
+         | stdart     |    411 | Underwater Basket Weaving        |       4 | This course provides a novel     |
+         :            :        :                                  :         : perspective on the traditional   :
+         :            :        :                                  :         : art of basketry as it is         :
+         :            :        :                                  :         : experienced in reduced gravity   :
+         :            :        :                                  :         : and in the context of fluid      :
+         :            :        :                                  :         : dynamics. Requires instructor    :
+         :            :        :                                  :         : permission and a valid c-card.   :
+         | stdart     |    509 | Twentieth Century Printmaking    |       4 | Development of personalized      |
+         :            :        :                                  :         : concepts and individual          :
+         :            :        :                                  :         : aesthetic expression in          :
+         :            :        :                                  :         : printmaking with reference to    :
+         :            :        :                                  :         : various styles and trends in     :
+         :            :        :                                  :         : Twentieth Century printmaking.   :
+         | stdart     |    512 | Art in Therapy                   |       3 | Surveys methods and results of   |
+         :            :        :                                  :         : using art and craft therapy with :
+         :            :        :                                  :         : developmentally disabled adults. :
+         | stdart     |    614 | Drawing Master Class             |       5 | For fine arts majors only, an    |
+         :            :        :                                  :         : intensive studio study including :
+         :            :        :                                  :         : field trips to local parks and   :
+         :            :        :                                  :         : museums and a final group art    :
+         :            :        :                                  :         : show.                            :
+         | tched      |    122 | Theory and Practice of Early     |       3 | Emphasis on the skills and       |
+         :            :        : Childhood Education              :         : processes needed for the design  :
+         :            :        :                                  :         : and implementation of optimal    :
+         :            :        :                                  :         : learning environments.           :
+         :            :        :                                  :         : Exploration of issues related to :
+         :            :        :                                  :         : societal and cultural influences :
+         :            :        :                                  :         : on the education of young        :
+         :            :        :                                  :         : children.                        :
+         | tched      |    155 | Methods of Early Science         |       3 | A study of the curriculum        |
+         :            :        : Education                        :         : methods, concepts, techniques,   :
+         :            :        :                                  :         : and materials in the teaching of :
+         :            :        :                                  :         : general science to children in   :
+         :            :        :                                  :         : the early grades.                :
+         | tched      |    367 | Problems in Education Management |       3 | This course is designed to       |
+         :            :        :                                  :         : assist the student to prepare    :
+         :            :        :                                  :         : for management of educational    :
+         :            :        :                                  :         : organizations and programs.      :
+         :            :        :                                  :         : Emphasis will be placed upon     :
+         :            :        :                                  :         : identifying specific problems    :
+         :            :        :                                  :         : and developing specific          :
+         :            :        :                                  :         : techniques by which to solve     :
+         :            :        :                                  :         : them.                            :
+         | tched      |    501 | Challenges of Teaching the       |       3 | The nature and needs of the      |
+         :            :        : Gifted and Talented              :         : talented and gifted in all areas :
+         :            :        :                                  :         : of development are explored.     :
+         | tched      |    609 | Supervised Internship in         |       4 | Supervised Internship I provides |
+         :            :        : Education                        :         : on-site, supervised              :
+         :            :        :                                  :         : instructional experience within  :
+         :            :        :                                  :         : a public school setting under    :
+         :            :        :                                  :         : the leadership of an             :
+         :            :        :                                  :         : appropriate, competent           :
+         :            :        :                                  :         : professional.                    :
+                                                                                                       (89 rows)
+
+         ----
+         /course?credits>=3
+         SELECT "course"."department", "course"."number", "course"."title", "course"."credits", "course"."description" FROM "ad"."course" AS "course" WHERE ("course"."credits" >= 3) ORDER BY 1 ASC, 2 ASC
+    - uri: /department?code>'me'
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (department?code>'me')              |
+        -+-------------------------------------+-
+         | code   | name              | school |
+        -+--------+-------------------+--------+-
+         | mth    | Mathematics       | ns     |
+         | parent | Parents & Alumni  |        |
+         | phys   | Physics           | ns     |
+         | pia    | Piano             | mus    |
+         | poli   | Political Science | la     |
+         | psych  | Psychology        | la     |
+         | stdart | Studio Art        | art    |
+         | str    | Strings           | mus    |
+         | tched  | Teacher Education | edu    |
+         | voc    | Vocals            | mus    |
+         | win    | Wind              | mus    |
+                                       (11 rows)
+
+         ----
+         /department?code>'me'
+         SELECT "department"."code", "department"."name", "department"."school" FROM "ad"."department" AS "department" WHERE ("department"."code" > 'me') ORDER BY 1 ASC
+    - uri: /{true(), false(), null()}
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         |                           |
+        -+---------------------------+-
+         | true() | false() | null() |
+        -+--------+---------+--------+-
+         | true   | false   |        |
+                               (1 row)
+
+         ----
+         /{true(),false(),null()}
+         SELECT TRUE, FALSE, NULL
+    - uri: /department{code, name}?is_null(school)
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (department?is_null(school)) |
+        -+------------------------------+-
+         | code    | name               |
+        -+---------+--------------------+-
+         | bursar  | Bursar's Office    |
+         | career  | Career Development |
+         | parent  | Parents & Alumni   |
+                                 (3 rows)
+
+         ----
+         /department{code,name}?is_null(school)
+         SELECT "department"."code", "department"."name" FROM "ad"."department" AS "department" WHERE ("department"."school" IS NULL) ORDER BY 1 ASC
+    - uri: /department{code, name}?!is_null(school)
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (department?!is_null(school))   |
+        -+---------------------------------+-
+         | code   | name                   |
+        -+--------+------------------------+-
+         | acc    | Accounting             |
+         | arthis | Art History            |
+         | astro  | Astronomy              |
+         | be     | Bioengineering         |
+         | capmrk | Capital Markets        |
+         | chem   | Chemistry              |
+         | comp   | Computer Science       |
+         | corpfi | Corporate Finance      |
+         | edpol  | Educational Policy     |
+         | ee     | Electrical Engineering |
+         | eng    | English                |
+         | hist   | History                |
+         | lang   | Foreign Languages      |
+         | me     | Mechanical Engineering |
+         | mth    | Mathematics            |
+         | phys   | Physics                |
+         | pia    | Piano                  |
+         | poli   | Political Science      |
+         | psych  | Psychology             |
+         | stdart | Studio Art             |
+         | str    | Strings                |
+         | tched  | Teacher Education      |
+         | voc    | Vocals                 |
+         | win    | Wind                   |
+                                   (24 rows)
+
+         ----
+         /department{code,name}?!is_null(school)
+         SELECT "department"."code", "department"."name" FROM "ad"."department" AS "department" WHERE ("department"."school" IS NOT NULL) ORDER BY 1 ASC
+    - uri: /course?department='acc'&credits<3
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?department='acc'&credits<3)                                 |
+        -+---------------------------------------------------------------------+-
+         | department | number | title                 | credits | description |
+        -+------------+--------+-----------------------+---------+-------------+-
+         | acc        |    100 | Practical Bookkeeping |       2 |             |
+                                                                         (1 row)
+
+         ----
+         /course?department='acc'&credits<3
+         SELECT "course"."department", "course"."number", "course"."title", "course"."credits", "course"."description" FROM "ad"."course" AS "course" WHERE (("course"."department" = 'acc') AND ("course"."credits" < 3)) ORDER BY 1 ASC, 2 ASC
+    - uri: /course?credits>4|credits<3
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?credits>4|credits<3)                                                                      |
+        -+---------------------------------------------------------------------------------------------------+-
+         | department | number | title                          | credits | description                      |
+        -+------------+--------+--------------------------------+---------+----------------------------------+-
+         | acc        |    100 | Practical Bookkeeping          |       2 |                                  |
+         | acc        |    315 | Financial Accounting           |       5 | Integration of the conceptual    |
+         :            :        :                                :         : and computational aspects of     :
+         :            :        :                                :         : asset, liability and             :
+         :            :        :                                :         : stockholders equity accounting.  :
+         | astro      |    142 | Solar System Lab               |       2 | Laboratory studies that          |
+         :            :        :                                :         : complement the lecture course    :
+         :            :        :                                :         : ASTRO 137.                       :
+         | astro      |    155 | Telescope Workshop             |       1 | Introduction to correct use of   |
+         :            :        :                                :         : the 8-inch Schmidt-Cassegrain    :
+         :            :        :                                :         : type telescope. You will learn   :
+         :            :        :                                :         : about magnification, how to      :
+         :            :        :                                :         : locate an object, and how        :
+         :            :        :                                :         : setting circles work.            :
+         | be         |    415 | Internship in Biomedical       |       8 | The student will work twenty     |
+         :            :        : Engineering                    :         : hours per week in an area firm   :
+         :            :        :                                :         : to gain experience in the        :
+         :            :        :                                :         : application of biomedical        :
+         :            :        :                                :         : engineering principles in an     :
+         :            :        :                                :         : industrial setting.              :
+         | chem       |    115 | Organic Chemistry Laboratory I |       2 | Complements Organic Chemistry I. |
+         :            :        :                                :         : Practical laboratory             :
+         :            :        :                                :         : experiments.                     :
+         | eng        |    175 | College Newspaper              |       2 | Students will perform            |
+         :            :        :                                :         : journalistic writing exercises   :
+         :            :        :                                :         : for publication in the college   :
+         :            :        :                                :         : newspaper.                       :
+         | eng        |    412 | Ecology Writing Workshop       |       2 | This monthly workshop will focus |
+         :            :        :                                :         : on creation of a course          :
+         :            :        :                                :         : assignment, a feature-length     :
+         :            :        :                                :         : magazine article covering a      :
+         :            :        :                                :         : complex topic in ecology.        :
+         | lang       |    304 | Spanish Conversation Group     |       2 | Informal weekly conversation     |
+         :            :        :                                :         : group designed to improve        :
+         :            :        :                                :         : understanding of spoken Spanish. :
+         :            :        :                                :         : Suitable for both majors and     :
+         :            :        :                                :         : casual speakers who wish to      :
+         :            :        :                                :         : improve their skills for         :
+         :            :        :                                :         : personal enjoyment or travel.    :
+         | mth        |    101 | College Algebra                |       5 | This course, taken mostly by     |
+         :            :        :                                :         : members from the School of       :
+         :            :        :                                :         : Business is a primary graduate   :
+         :            :        :                                :         : student funding vehicle for the  :
+         :            :        :                                :         : the Department of                :
+         :            :        :                                :         : Mathematics.  This is a 1000     :
+         :            :        :                                :         : person lecture reviews basic     :
+         :            :        :                                :         : concepts taught in high school.  :
+         | phys       |    388 | Experimental Physics I         |       2 | In this course students will     |
+         :            :        :                                :         : perform several experiments in   :
+         :            :        :                                :         : different areas of physics. They :
+         :            :        :                                :         : will also learn fundamental      :
+         :            :        :                                :         : experimental techniques and how  :
+         :            :        :                                :         : to record and report results and :
+         :            :        :                                :         : perform analysis.                :
+         | stdart     |    614 | Drawing Master Class           |       5 | For fine arts majors only, an    |
+         :            :        :                                :         : intensive studio study including :
+         :            :        :                                :         : field trips to local parks and   :
+         :            :        :                                :         : museums and a final group art    :
+         :            :        :                                :         : show.                            :
+         | stdart     |    714 | Peer Portfolio Review          |       0 | An opportunity to practice       |
+         :            :        :                                :         : giving and receiving             :
+         :            :        :                                :         : constructive criticism.          :
+                                                                                                     (13 rows)
+
+         ----
+         /course?credits>4|credits<3
+         SELECT "course"."department", "course"."number", "course"."title", "course"."credits", "course"."description" FROM "ad"."course" AS "course" WHERE (("course"."credits" > 4) OR ("course"."credits" < 3)) ORDER BY 1 ASC, 2 ASC
+    - uri: /{true()|false()&false(),(true()|false())&false()}
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         |                                                   |
+        -+---------------------------------------------------+-
+         | true()|false()&false() | (true()|false())&false() |
+        -+------------------------+--------------------------+-
+         | true                   | false                    |
+                                                       (1 row)
+
+         ----
+         /{true()|false()&false(),(true()|false())&false()}
+         SELECT TRUE, FALSE
+    - uri: /course?(department='arthis'|department='stdart')&credits>3
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?(department='arthis'|department='stdart')&credits>3)                                     |
+        -+--------------------------------------------------------------------------------------------------+-
+         | department | number | title                         | credits | description                      |
+        -+------------+--------+-------------------------------+---------+----------------------------------+-
+         | arthis     |    712 | Museum and Gallery Management |       4 | Supervised independent field     |
+         :            :        :                               :         : experience and practical work in :
+         :            :        :                               :         : all areas of Art Museum          :
+         :            :        :                               :         : management in the university and :
+         :            :        :                               :         : greater metropolitan area        :
+         :            :        :                               :         : communities.                     :
+         | stdart     |    411 | Underwater Basket Weaving     |       4 | This course provides a novel     |
+         :            :        :                               :         : perspective on the traditional   :
+         :            :        :                               :         : art of basketry as it is         :
+         :            :        :                               :         : experienced in reduced gravity   :
+         :            :        :                               :         : and in the context of fluid      :
+         :            :        :                               :         : dynamics. Requires instructor    :
+         :            :        :                               :         : permission and a valid c-card.   :
+         | stdart     |    509 | Twentieth Century Printmaking |       4 | Development of personalized      |
+         :            :        :                               :         : concepts and individual          :
+         :            :        :                               :         : aesthetic expression in          :
+         :            :        :                               :         : printmaking with reference to    :
+         :            :        :                               :         : various styles and trends in     :
+         :            :        :                               :         : Twentieth Century printmaking.   :
+         | stdart     |    614 | Drawing Master Class          |       5 | For fine arts majors only, an    |
+         :            :        :                               :         : intensive studio study including :
+         :            :        :                               :         : field trips to local parks and   :
+         :            :        :                               :         : museums and a final group art    :
+         :            :        :                               :         : show.                            :
+                                                                                                     (4 rows)
+
+         ----
+         /course?(department='arthis'|department='stdart')&credits>3
+         SELECT "course"."department", "course"."number", "course"."title", "course"."credits", "course"."description" FROM "ad"."course" AS "course" WHERE ((("course"."department" = 'arthis') OR ("course"."department" = 'stdart')) AND ("course"."credits" > 3)) ORDER BY 1 ASC, 2 ASC
+    - uri: /course?department='arthis'|department='stdart'&credits>3
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?department='arthis'|department='stdart'&credits>3)                                         |
+        -+----------------------------------------------------------------------------------------------------+-
+         | department | number | title                           | credits | description                      |
+        -+------------+--------+---------------------------------+---------+----------------------------------+-
+         | arthis     |    202 | History of Art Criticism        |       3 | An introductory survey course on |
+         :            :        :                                 :         : Prehistoric through              :
+         :            :        :                                 :         : late-Medieval art history.       :
+         | arthis     |    340 | Arts of Asia                    |       3 | An introduction to the history   |
+         :            :        :                                 :         : and criticism of Far Eastern     :
+         :            :        :                                 :         : art, including the art of China  :
+         :            :        :                                 :         : and Japan, fine and decorative   :
+         :            :        :                                 :         : arts.                            :
+         | arthis     |    623 | Contemporary Latin American Art |       3 | A survey of the last twenty      |
+         :            :        :                                 :         : years of Latin American art with :
+         :            :        :                                 :         : a focus on the Caribbean and     :
+         :            :        :                                 :         : Central America.                 :
+         | arthis     |    710 | Methods in Art History          |       3 | This seminar focuses on basic    |
+         :            :        :                                 :         : types of art-historical method.  :
+         :            :        :                                 :         : Some meetings focus on a single  :
+         :            :        :                                 :         : author who exemplifies a         :
+         :            :        :                                 :         : particular approach.             :
+         | arthis     |    712 | Museum and Gallery Management   |       4 | Supervised independent field     |
+         :            :        :                                 :         : experience and practical work in :
+         :            :        :                                 :         : all areas of Art Museum          :
+         :            :        :                                 :         : management in the university and :
+         :            :        :                                 :         : greater metropolitan area        :
+         :            :        :                                 :         : communities.                     :
+         | arthis     |    809 | Materials and Construction in   |       3 | A scientific examination of the  |
+         :            :        : European Art                    :         : materials and manufacturing      :
+         :            :        :                                 :         : techniques employed in Europe    :
+         :            :        :                                 :         : over the last two centuries.     :
+         | stdart     |    411 | Underwater Basket Weaving       |       4 | This course provides a novel     |
+         :            :        :                                 :         : perspective on the traditional   :
+         :            :        :                                 :         : art of basketry as it is         :
+         :            :        :                                 :         : experienced in reduced gravity   :
+         :            :        :                                 :         : and in the context of fluid      :
+         :            :        :                                 :         : dynamics. Requires instructor    :
+         :            :        :                                 :         : permission and a valid c-card.   :
+         | stdart     |    509 | Twentieth Century Printmaking   |       4 | Development of personalized      |
+         :            :        :                                 :         : concepts and individual          :
+         :            :        :                                 :         : aesthetic expression in          :
+         :            :        :                                 :         : printmaking with reference to    :
+         :            :        :                                 :         : various styles and trends in     :
+         :            :        :                                 :         : Twentieth Century printmaking.   :
+         | stdart     |    614 | Drawing Master Class            |       5 | For fine arts majors only, an    |
+         :            :        :                                 :         : intensive studio study including :
+         :            :        :                                 :         : field trips to local parks and   :
+         :            :        :                                 :         : museums and a final group art    :
+         :            :        :                                 :         : show.                            :
+                                                                                                       (9 rows)
+
+         ----
+         /course?department='arthis'|department='stdart'&credits>3
+         SELECT "course"."department", "course"."number", "course"."title", "course"."credits", "course"."description" FROM "ad"."course" AS "course" WHERE (("course"."department" = 'arthis') OR (("course"."department" = 'stdart') AND ("course"."credits" > 3))) ORDER BY 1 ASC, 2 ASC
+    - uri: /course?!(department='arthis'|department='stdart')
+      status: 200 OK
+      headers:
+      - [Content-Type, text/plain; charset=UTF-8]
+      body: |2
+         | (course?!(department='arthis'|department='stdart'))                                                 |
+        -+-----------------------------------------------------------------------------------------------------+-
+         | department | number | title                            | credits | description                      |
+        -+------------+--------+----------------------------------+---------+--------------------------------