```json { "queries": [ { "query": "SELECT * FROM callyeah_analytics_2026_07_23 LIMIT 10", "description": "Preview first 10 rows of the entire dataset." }, { "query": "SELECT COUNT(*) AS total_rows FROM callyeah_analytics_2026_07_23", "description": "Total number of rows in the dataset." }, { "query": "SELECT \"CallYeah — Analytics Export\", \"Unnamed: 1\", \"Unnamed: 2\", \"Unnamed: 3\", \"Unnamed: 4\" FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 4\" IS NOT NULL AND \"Unnamed: 3\" IS NOT NULL LIMIT 10", "description": "First 10 rows with data in both column 3 and column 4." }, { "query": "SELECT \"Unnamed: 7\", COUNT(*) AS frequency FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 7\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10", "description": "Most frequent values in column 7." }, { "query": "SELECT \"Unnamed: 8\", COUNT(*) AS occurrences FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 8\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10", "description": "Most common values in column 8." }, { "query": "SELECT \"Unnamed: 6\", COUNT(*) AS count FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 6\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10", "description": "Distribution of values in column 6." }, { "query": "SELECT \"Unnamed: 1\", \"Unnamed: 5\", \"Unnamed: 9\" FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 1\" IS NOT NULL AND \"Unnamed: 5\" IS NOT NULL AND \"Unnamed: 9\" IS NOT NULL LIMIT 10", "description": "Rows with data in columns 1, 5, and 9." }, { "query": "SELECT COUNT(*) AS filled_rows FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 4\" IS NOT NULL AND \"Unnamed: 5\" IS NOT NULL AND \"Unnamed: 6\" IS NOT NULL", "description": "Count of rows with data in columns 4, 5, and 6." }, { "query": "SELECT \"Unnamed: 2\", \"Unnamed: 3\", \"Unnamed: 7\" FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 2\" IS NOT NULL AND \"Unnamed: 7\" IS NOT NULL LIMIT 15", "description": "Rows showing columns 2, 3, and 7 where columns 2 and 7 have data." }, { "query": "SELECT COUNT(DISTINCT \"Unnamed: 4\") AS unique_col4, COUNT(DISTINCT \"Unnamed: 5\") AS unique_col5, COUNT(DISTINCT \"Unnamed: 6\") AS unique_col6 FROM callyeah_analytics_2026_07_23", "description": "Number of unique values in columns 4, 5, and 6." } ] } ```