More queries?

These queries would be most interesting for the end user:

1. last slot number, block number, last transaction of a given smart contract - demos for one-shot
2. average transaction fees, and transaction volumes per block, for the last N blocks - demos for SSE and query performance (frontend will make it a graph of it: https://poocoin.app/)
3. Average price of a MILK token on MuesliSwap, or another token on SundaeSwap for the last N days

Here are some: https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/interesting-queries.md

Both server-sent events as well as simple one-shot queries?