Skip to content

SQL Examples

Jump to bottom
Nicky Harpor edited this page Nov 14, 2021 · 11 revisions

Findora SQL CLI renders complex queries effectively. This page showcases some of the possibilities.

How many transactions moved more than 100 million FRA?

SELECT COUNT(*) FROM forge_tx WHERE value > 100000000000000000

What's the average gas price today?

SELECT AVG(gasPrice) FROM forge_tx WHERE timestamp > TODAY()
Clone this wiki locally