Remove rows based on condition

Hi there-

Does anyone know how to conditionally remove rows in Query Editor based on one simple condition? I'm appending a few queries together, each of them have rows that are mostly blank but do require me to have some text information and 0's in columns.

Ultimately, I'd like to create a rollup of the queries but exclude anyrows that contain 0's in the "Hours / wk" column (see below). - unfortunately, these rows are necessary on the worksheets these queries are being created from but on the backend when I append them, I'd like them removed

Thanks so much for any help!!