Get Post Count From Blog ID

I'm working on improving the information provided from blogs (via SiteAdmin), I intend to display the post count per blog.

Does anyone know the sql query to get the post count given the blog_id?

Many thanks.