It is just a simple WHERE clause

WHERE YourFieldName = "ADJUSTMENT"

and the same with the other categories.