-- ============================
-- All Tables - Quick Preview
-- ============================
-- List all data in sectors
SELECT * FROM sectors;
-- List all data in symbols
SELECT * FROM symbols;
-- List all data in prices_latest
SELECT * FROM prices_latest;
-- List 100 records from prices_historical table
SELECT * FROM prices_historical LIMIT 100
-- ==========================
-- SECTORS Analysis
-- ==========================
-- List all sectors
SELECT * FROM sectors;
-- List all sectors by sector_name in Ascending order
SELECT * FROM sectors ORDER BY sector_name ASC;
SELECT * FROM sectors ORDER BY sector_name ASC;
-- List all sectors in by sector_name in Descending order
SELECT * FROM sectors ORDER BY sector_name DESC;
-- List all sectors where sector_names contains 'Financial'
SELECT * FROM sectors WHERE sector_name LIKE '%Financial%'