✨ VOLUNTEER OF THE MONTH: ABEEDAT USMAN NURUDEEN ✨
Some people talk about kindness. Others live it quietly, consistently, and wholeheartedly. Abeedat has been that light for us at The Esther Daniels Ikeme Foundation (TEDIF).
Today we celebrate Abel Ohikpo.
A valued member of our Research Team! Thank you for all you do to make our mission stronger. Wishing you a year full of growth and light
For instance, you can use UNION to combine transaction data from Ethereum and Cosmos blockchains, removing duplicates. Alternatively, UNION ALL would include all transactions, even if they're identical.
Data source: @Dune
Data Community: @AnalyticSages
It’s been 2 weeks of blockchain data analytics classes with @AnalyticSages and it’s been quite an interesting journey so far.
I worked on the daily transfer volume of @Zora, I checked for the sum and average of the daily transfer.
UNION: it removes duplicate rows from the combined result set, ensuring unique records.
UNION ALL: it includes all rows from the combined result sets, preserving duplicates.
I recently took the bold step of taking a blockchain data analysis course with @AnalyticSages I was taught the basics of blockchain, data and SQL flavors by @smartymetrics on this thread I’ll be talking on the differences between MySQL, PostgreSQL, trinoSQL and snowflake.
Features: it includes role‑based access control, end‑to‑end encryption, automated data masking, and a unified audit log for strong security and governance; virtual warehouses that scale compute independently of storage, query‑result caching, and automatic query optimization.