Report on Test Step Execution within QC

Hi,
Does anyone know how to create a report or have SQL to pull info on teststeps being run for my work in testlab...Folders and subfolders.

Would want a count on Steps passed, Failed etc etc.

Would be really useful,
Thanks