漏斗 SQL 设计
测试模型能否把业务漏斗转成可查询逻辑。
Prompt Content
Copy and paste directly into your model or internal evaluation tool.
事件表 events(user_id, event_name, event_time)。请写 SQL 统计 7 天内从 signup 到 activation 再到 purchase 的用户漏斗转化，要求同一用户事件按时间顺序发生。
Use Cases
Reference Output
应按用户聚合各步骤首次发生时间，并保证 signup <= activation <= purchase 且 purchase 在 signup 后7天内。
Scoring Rubric
看时间顺序、窗口约束和去重处理。
Try & save
Fill variables and copy, or save as a personal template.
This template has no variables and is ready to copy.
User Rating
0 ratingsYour rating
Log in to rate
Comments
0Log in to comment
Related Prompts
SQL Query Explainer for Non-Engineers
Translate complex SQL queries into business-friendly language, covering business questions, table relationships, filters, and potential risks.
Image Analysis for Night Portrait in Heavy Snowfall
Analyzes a photo of a night portrait in heavy snowfall, providing detailed metadata on environment, lighting, people, and objects.
Bank Transaction Analysis
As a financial analyst, sort and detect anomalies in bank transaction data.
Virtualization Solutions Expert Comparative Analysis
As a virtualization expert, compare top virtualization solutions in the market, covering key features, performance benchmarks, scalability, and cost-effectiveness.