count entries with given status/channel in expressionengine

gistfile1.txt

{exp:query sql="
 SELECT 
  COUNT(entry_id) AS total_entry_count
 FROM
  exp_channel_titles
 WHERE
  channel_id = 1 AND status = 'open'
"} 

 {total_entry_count}
 
{/exp:query}