DATABASE SQL QUERY

Display all information on vendors order by vendor number ascending where the vendor name does not end in a o.

VEN_NO VEN_NAME VEN_STREET VEN_CITY VEN_STATE VEN_ZIPCODE VEN_PNONE VEN_FAX

------ ------------------------- ------------------------- -------------------- --------- ----------- ---------- ----------

THIS WHAT I HAVE SO FAR:

select * from vendor where ???? order by ven_no asc;