-- John Aromando -- SQL Numeric Criteria --

use ogcPubLev1


select pubdate,devcost, bktitle
from titles
where devcost <> 13187.06 --not equals
order by devcost desc

select pubdate,devcost, bktitle
from titles
where devcost > 13187.06 
order by devcost desc

select pubdate,devcost, bktitle
from titles
where devcost < 13187.06 
order by devcost desc

select pubdate,devcost, bktitle
from titles
where devcost >= 13187.06 
order by devcost desc

select pubdate,devcost, bktitle
from titles
where devcost <= 13187.06 
order by devcost desc

select pubdate, devcost, bktitle
from titles
where devcost is not NULL
order by devcost desc

select pubdate, devcost, bktitle
from titles
where devcost >= 13445.62 or devcost <= 13187.06 --interior range
order by devcost desc

select pubdate, devcost, bktitle
from titles
where devcost between 13187.06 and 13445.62 --first = lowest, second = highest (inclusive for test values)
order by devcost desc

select pubdate,devcost, bktitle
from titles
where not (devcost between 13187.06 and 13445.62) --exterior
order by devcost desc