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 demoStep 1. Open the query screen for payments. Open queries
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 DESCStep 3. Press Run.
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.Step 5. Go back to the data home and find it under Saved queries. Open data
Did it fit your work?