Quality Assurance & Testing resources who leverage HP ALM for all aspects of STLC lifecycle and methodologies can leverage the LIVE SQL queries in this book, which is a good collection of them (but not an exhaustive one), tweak & fine tune them to suit their projects that is adhering to Waterfall or Agile methodologies. If you are using HP ALM 12.0 & above there is a separate link provided within the document that walks you through the step by step process instead of the regular SQL queries.