-- ============================

-- 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%'