query-writing

What problem does it solve?

This skill helps analysts and developers translate questions into executable SQL queries, enabling fast data-driven answers without manual query drafting.

Core Features & Use Cases

• Single-table queries: Retrieve targeted data from a single table with filters and ordering.
• Multi-table joins & aggregations: Build joins across tables and compute aggregates for comprehensive reports.
• Use Case: Imagine you need total revenue by country from a sales database; this skill guides you from schema inspection to a final, ready-to-run query.

Quick Start

请用此技能编写并执行一个 SQL 查询来回答问题，例如：为每个国家计算总收入，按降序返回前5条。