skills.rest
xiaonanji
xiaonanjiCOMMUNITY
Explore all skills by this author →
GitHub

amo-summary-2026

Query AMO 2026 SQLite data to summarize award distributions and student demographics.

Updated Apr 3, 2026
Search Tags:#sqlite#query#data-analysis#analyze#amo#award-distribution#education-data
One-click install
npx skills add https://github.com/xiaonanji/ask_jeremy_v3 --skill amo-summary-2026
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: amo-summary-2026
Source: https://github.com/xiaonanji/ask_jeremy_v3/tree/main/.agents/skills/amo-summary-2026
Command: npx skills add https://github.com/xiaonanji/ask_jeremy_v3 --skill amo-summary-2026

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

AMO 2026 data resides in a SQLite table and needs quick, repeatable analysis to surface award distributions and student demographics.

Core Features & Use Cases

  • Query the amo_summary_2026 table to compute counts by award (Honourable Mention, Bronze, Silver, Gold, Gold with Perfect Score) and summarize by year, state, and school.
  • Generate basic statistics such as counts of students and where scores are missing, enabling trend analysis across years and regions.
  • Use case: a data analyst wants a compact report showing award distribution by state for AMO 2026.

Quick Start

Query the amo_summary_2026 SQLite database to extract and summarize award distributions by year, state, and school.

Frequently Asked Questions about amo-summary-2026

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze AMO 2026 award distributions in SQLite?▼

To analyze AMO 2026 award distributions in SQLite, query the amo_summary_2026 table to compute counts by award type and summarize results by year, state, and school.

How do I handle null scores for Honourable Mention in AMO data analysis?▼

When handling null scores for Honourable Mention in AMO data analysis, the system automatically manages missing values during SQLite queries to ensure accurate student counts and aggregates.

Can I generate state-level summary reports for AMO 2026 student demographics?▼

Yes, you can generate state-level summary reports for AMO 2026 student demographics by filtering the SQLite dataset by state, award, and year to surface targeted insights.

What is the best way to export aggregated AMO 2026 data from a SQLite database?▼

The best way to export aggregated AMO 2026 data from a SQLite database is to run structured queries on the amo_summary_2026 table and export the results to common formats.

Does basic SQLite analysis support medium-sized AMO education datasets?▼

Basic SQLite analysis supports small to medium-sized AMO education datasets, allowing you to filter, aggregate, and analyze award distributions without external dependencies.

Related Skills

Explore More Data & Analytics Skills→
tilmon-engineeringtilmon-engineering
3

using-sqlite

Guide CLI-driven SQLite workflows for schema discovery, querying, and CSV import.

Official
Basic
pinion05pinion05
3

health-data

Query Apple Health SQLite data and export summaries as Markdown, JSON, or FHIR R4.

Community
Intermediate
bradtaylorsfbradtaylorsf
8

sqlite-optimization

Optimize SQLite performance with PRAGMA settings, query analysis, and indexing strategies.

Community
Advanced
OpenSenseNovaOpenSenseNova
4.9k

pivot-table-cross-analysis

Analyze Excel categorical data with cross-tabulations and heatmaps.

Official
Intermediate