I commit whitespace. sue me
object aliases do not propagate to subqueries
renamed view deviceStatus to simply status for brevity
renamed cv.status.psql to cv.status.pgsql for not making typos in our filenames
terminate statements with a semicolon