The query does not appear to work with the "SQL Query Executor" tool in the Zen Cart admin. However this is definitely a valid query for the server information that the page displayed.

Do you have an alternative DB management tool, like phpMyAdmin? Your host almost certainly provides some interface to your databases via Cpanel or Plesk. I always recommend that you use those tools whenever possible, as the SQL tool in Zen Cart does have its moments.