SMB Pulse

Answer a one-off question with SQL, and keep it

Write your own question over the payments data, run it, and save it so you or others can ask it again.

Pick a use case and follow its guide

Answer a one-off question with SQL, and keep it

0 of 5 steps done

Sign in to try the demo
  1. Step 1. Open the query screen for payments. Open queries

  2. Step 2. Type a question over the model's tables, for example the fees each processor charged: SELECT processor, SUM(gross) AS gross, SUM(fee) AS fees, SUM(net) AS net FROM settlements GROUP BY processor ORDER BY gross DESC

  3. Step 3. Press Run.

  4. Step 4. Press Save, give it a question in plain words, such as What did each processor charge us in fees?, and a one-line description.

  5. Step 5. Go back to the data home and find it under Saved queries. Open data

Did it fit your work?