Covered common SQL commands:

• select
• from
• where
• limit
• join
• date_trunc
• order by
• between
• !=
• aggregates
• alias

Select

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.

JOIN, ORDER BY, ASC, BETWEEN

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