```json { "queries": [ { "query": "SELECT \"AEDECOD\", COUNT(*) AS event_count FROM ae GROUP BY \"AEDECOD\" ORDER BY event_count DESC LIMIT 10", "description": "Top 10 most frequently reported adverse events in the study." }, { "query": "SELECT \"AESEV\", COUNT(*) AS count FROM ae WHERE \"AESEV\" IS NOT NULL GROUP BY \"AESEV\" ORDER BY count DESC", "description": "Distribution of adverse events by severity level." }, { "query": "SELECT \"ARM\", COUNT(*) AS subject_count FROM adsl WHERE \"ARM\" IS NOT NULL GROUP BY \"ARM\" ORDER BY subject_count DESC", "description": "Number of subjects enrolled in each treatment arm." }, { "query": "SELECT \"AGEGR1\", \"SEX\", COUNT(*) AS count FROM adsl WHERE \"AGEGR1\" IS NOT NULL AND \"SEX\" IS NOT NULL GROUP BY \"AGEGR1\", \"SEX\" ORDER BY count DESC", "description": "Subject demographics showing age group and sex distribution." }, { "query": "SELECT \"AEBODSYS\", COUNT(*) AS event_count FROM ae WHERE \"AEBODSYS\" IS NOT NULL GROUP BY \"AEBODSYS\" ORDER BY event_count DESC LIMIT 10", "description": "Top 10 body systems affected by adverse events." }, { "query": "SELECT \"RACE\", AVG(\"AGE\") AS avg_age FROM adsl WHERE \"AGE\" IS NOT NULL AND \"RACE\" IS NOT NULL GROUP BY \"RACE\" ORDER BY avg_age DESC", "description": "Average age of subjects by race category." }, { "query": "SELECT \"AEREL\", COUNT(*) AS count FROM ae WHERE \"AEREL\" IS NOT NULL GROUP BY \"AEREL\" ORDER BY count DESC", "description": "Adverse events grouped by relationship to study treatment." }, { "query": "SELECT \"AEOUT\", COUNT(*) AS outcome_count FROM ae WHERE \"AEOUT\" IS NOT NULL GROUP BY \"AEOUT\" ORDER BY outcome_count DESC", "description": "Distribution of adverse event outcomes." }, { "query": "SELECT \"COUNTRY\", COUNT(*) AS subject_count FROM adsl WHERE \"COUNTRY\" IS NOT NULL GROUP BY \"COUNTRY\" ORDER BY subject_count DESC", "description": "Number of subjects enrolled by country." }, { "query": "SELECT ae.\"AEDECOD\", COUNT(*) AS count FROM ae JOIN adsl ON ae.\"USUBJID\" = adsl.\"USUBJID\" WHERE adsl.\"ARM\" = 'Placebo' GROUP BY ae.\"AEDECOD\" ORDER BY count DESC LIMIT 10", "description": "Top 10 adverse events reported in the Placebo arm." } ] } ```