how to delete all archived blogs via SQL?

I've been doing some spring cleaning and have archived plenty of unused blogs.
I'll give them a few weeks but if nobody complains, I'd like to delete all archived blogs in one swoop via a SQL command. can someone help me out here?