如何在SQL查询中按月份生成两类用户的任务完成时长平均值

Core Formatting Techniques #

• Headings: Use # for different levels—one # for main headings, two ## for subheadings, three ### for deeper sections.

  Main Heading #

  Subheading #

  Section Title #

• Bullet Lists: Start each item with a dash (-)

  • First list entry
  • Second list entry
  • Third list entry

• Text Emphasis: Wrap text in single asterisks for italic, or double asterisks for bold

  • Italicized text for subtle highlights
  • Bold text for key terms or critical notes

• Inline Code: Surround commands, snippets, or technical terms with backticks () Example: SELECT * FROM Ordersornpm run build`

• Blockquotes: Prefix quoted content with a greater-than sign (>)

"Simplicity is the ultimate sophistication." — Leonardo da Vinci

• Multi-line Code Blocks: Use triple backticks (```) before and after code, add a language tag for syntax highlighting

SELECT 
    MonthName,
    AVG(DATEDIFF(DAY, DateStarted, DateEnded)) AS AvgCompletionDays
FROM Tasks
WHERE DateStarted >= '20220101'
GROUP BY MonthName

• Links: Format as [Link Text](Target URL)
  Example: Internal Project Docs

• Images: Format as [Alt Text](Image File Path/URL)
  Example: Company Logo

内容的提问来源于stack exchange，提问作者PatBentley921