OGE transactions by ticker

Custom SQL query returning 100 rows (hide)

SELECT ticker, COUNT(*) AS n_tx,
    SUM(CASE WHEN tx_type LIKE '%Purchase%' THEN 1 ELSE 0 END) AS purchases,
    SUM(CASE WHEN tx_type LIKE '%Sale%' THEN 1 ELSE 0 END) AS sales,
    MIN(tx_date_iso) AS first_tx, MAX(tx_date_iso) AS last_tx
FROM oge_pas_transactions
WHERE ticker IS NOT NULL
GROUP BY ticker
ORDER BY n_tx DESC
LIMIT 100

Edit SQL