Covered common SQL commands:
A SQL SELECT statement retrieves records from a database table according to clauses ****(for example, FROM and WHERE ) that specify criteria
SELECT * FROM solana.events WHERE date(block_timestamp) >= '2021-12-01' LIMIT 10
The above example uses select, from, where, and limit commands.
The analyst “SELECTS” or chooses what data points they want to collect “FROM” the data table of their choosing. * is a signifier of what columns they want pulled from the table - in this case all columns. “WHERE” limits the criteria - in this example they only want to look at dates greater than December 21, 2021. “LIMIT” the results returned to 10 rows.
SELECT pt.sender ,t.block_timestamp::date FROM algorand.payment_transaction pt JOIN algorand.transactions t ON pt.block_id = t.block_id WHERE pt.block_timestamp::date BETWEEN '2022-03-01' AND '2022-03-15' ORDER BY 2 ASC LIMIT 10
Above example has 4 new conditions: JOIN, ORDER BY, ASC, BETWEEN