hello farcaster friends

i'm working on improving my sql and i thought it would be fun to practice with real data and answer real questions about the network we're all on 

so, if you've ever wondered something about the farcaster network and the data on it - shoot

examples of questions that i can answer with a sql query:
> what's the daily avg # of casts?
> what % of casts are just text?
> who has been the most mentioned user this week? 

(will answer as many as i can over the next couple of days!)

Erica is learning SQL and Postgres — throw some tough queries about Farcaster her way :)

bonus points if it requires a big data pipeline job. we will get @andywon.eth to run it tomorrow!

shared with @gif (follow @0xconca.eth to remove this watermark) https://media.tenor.com/sHGKHnikkM0AAAAC/thumbsup-cool https://media.tenor.com/lEg7E0amuHgAAAAC/cool-butt-head https://media.tenor.com/5BYK-WS0__gAAAAC/cool-fun https://media.tenor.com/-nW7efcGaiMAAAAC/kiss-cucumber https://media.tenor.com/AH-bMJdwYe0AAAAC/digilah-digifun https://media.tenor.com/g9I23ev4eGgAAAAC/emmy-amy-poehler https://media.tenor.com/Ofy3iyiFsoUAAAAC/what-dog

💻 building /hyperclient && @atlas && @gif composer action (check bio for details) | 👑 support me and @gif project by subbing to https://hypersub.xyz/s/gif

a Composer Action to search & share GIFs | try it: https://bit.ly/4dg55gk | premium: hypersub.xyz/s/gif | how to use: https://bit.ly/3TIOafc | dev: @0xconca.eth

👨‍💻 /uno and /outside, @unofficial