Navicat provides powerful tools for working with queries: Query Editor for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. Sometimes you win, sometimes you learn. Success consists of going from failure to failure without loss of enthusiasm.