nak --nostrx --sql 'SELECT id, sum(zaps.amount) FROM events WHERE kind = 10002 AND author = 'fa984bd7dbb282f07e16e7ae87b26a2a7b9b90b7246a44771f0cf5ae58018f52' INNER JOIN zaps ON zaps.target_id = events.id GROUP BY zaps.amount ORDER BY sum(zaps.amount)
It will connect straight to the Nostr BGS.
Login to reply