// Database schema and business logic for sales data analysis including customers, orders, and revenue.
Sample skill fixture for classpath registry enhancement tests.
ๅๅๆๆกๅไฝๅฉๆใๆ นๆฎๅๅไฟกๆฏ็ๆๅธๅผไบบ็่ฅ้ๆๆกใๅฝ็จๆทๆๅฐ"ๅๆๆก"ใ"ๅๅๆ่ฟฐ"ใ"่ฅ้ๆๆก"ๆถไฝฟ็จๆญคๆ่ฝใ
้ๅๅๆๅฉๆใๆ นๆฎๅธๅบ่ถๅฟๅ็จๆท้ๆฑ๏ผๅๆๅนถๆจ่้ๅ็ๅๅๅ็ฑปใๅฝ็จๆทๆๅฐ"้ๅ"ใ"ๅๅๆจ่"ใ"ๅ็ฑปๅๆ"ๆถไฝฟ็จๆญคๆ่ฝใ
Database schema and business logic for inventory tracking including products, warehouses, and stock levels.
Test skill for groupedTools. When executing this skill, use the record_result tool to record the result value.
Extract text, tables, and form data from PDF documents for analysis and processing. Use when user asks to extract, parse, or analyze PDF files.
| name | sales_analytics |
| description | Database schema and business logic for sales data analysis including customers, orders, and revenue. |
Active customers: status = 'active' AND signup_date <= CURRENT_DATE - INTERVAL '90 days'
Revenue calculation: Only count orders with status = 'completed'. Use total_amount from orders table.
High-value orders: Orders with total_amount > 1000
-- Get top 10 customers by revenue in the last quarter
SELECT c.customer_id, c.name, c.customer_tier, SUM(o.total_amount) as total_revenue
FROM customers c
JOIN orders o ON c.customer_id = o.customer_id
WHERE o.status = 'completed' AND o.order_date >= CURRENT_DATE - INTERVAL '3 months'
GROUP BY c.customer_id, c.name, c.customer_tier
ORDER BY total_revenue DESC LIMIT 10;