Sample SQL Queries to help you get insights from your SQL data

Explore a collection of carefully curated SQL queries designed to help you extract valuable insights from your data. Whether you're analyzing sales trends, tracking customer behavior, or optimizing business processes, these queries provide practical solutions to common data challenges, empowering you to make informed decisions with ease.

1. Find the Top 5 Highest Earning Employees by Department
2. Calculate Year-Over-Year Revenue Growth
3. Identify Customers with Consecutive Purchases Over Months
4. List All Products Never Purchased
5. Find Employees with Salary Greater Than the Department Average
6. Retrieve Customer Orders Along with Their Total Spend
7. Detect Database Anomalies in Transaction Amounts
8. Get Monthly Active Users (MAU)
9. Calculate the Retention Rate of Users
10. Generate a Cohort Analysis Report
11. Find the Average Order Value by Customer Segment
12. Identify Products with Increasing Sales Trend
13. Calculate the Average Time Between Purchases
14. Identify Employees Eligible for Promotion Based on Performance
15. Calculate the Total Revenue from Repeat Customers
16. Find the Top 10 Most Profitable Products
17. Calculate the Churn Rate of Subscription Customers
18. Identify the Top 5 Locations with the Highest Sales
19. Calculate the Average Customer Lifetime Value (CLV)
20. Find Products with the Highest Return Rate
21. Identify Seasonal Sales Trends
22. Calculate the Average Resolution Time for Support Tickets
23. Find the Top 5 Longest-Serving Employees
24. Identify Customers with High Potential for Upselling
25. Calculate the Average Inventory Turnover Ratio
26. Identify the Most Common Customer Complaints
27. Calculate the Employee Retention Rate
28. Identify the Top 10 Customers by Lifetime Value
29. Calculate the Contribution Margin by Product Category
30. Find the Top 5 Departments with the Highest Average Salaries
31. Identify the Most Popular Products by Region
32. Calculate the Net Promoter Score (NPS)
33. Find Employees with No Recent Performance Reviews
34. Calculate the Conversion Rate of Marketing Campaigns
35. Identify the Top 5 Suppliers by Order Volume
36. Calculate the Average Customer Satisfaction Score by Product
37. Identify the Most Frequently Returned Products
38. Calculate the Average Deal Size by Salesperson
39. Identify the Top 5 Most Engaged Users
40. Calculate the Average Customer Response Time for Support Tickets
41. Identify Products with the Highest Stockout Rates
42. Calculate the Average Time to Hire by Job Role
43. Find the Top 5 Most Visited Pages on a Website
44. Identify Employees with the Highest Number of Overtime Hours
45. Calculate the Average Order Fulfillment Time
46. Identify the Most Common Reasons for Support Ticket Escalations
47. Calculate the Average Customer Acquisition Cost (CAC)
48. Identify the Most Profitable Customer Segments
49. Calculate the Average Number of Items Per Order
50. Calculate the daily signup count
51. Calculate the weekly signup count
52. Calculate Monthly Recurring Revenue (MRR)
53. Calculate Annual Recurring Revenue (ARR)
54. Calculate Average Revenue Per User (ARPU)
55. Track MRR Expansion and Contraction
56. Calculate Trial-to-Paid Conversion Rate
57. Calculate Revenue Churn Rate
58. Calculate Customer Acquisition Cost by Channel
59. Calculate LTV to CAC Ratio
60. Calculate Net Revenue Retention (NRR)
61. Calculate DAU/MAU Ratio (Stickiness)
62. Track Feature Adoption Rate
63. Calculate Time to First Value (TTFV)
64. Calculate User Activation Rate
65. Track Signup to Activation Funnel
66. Calculate CAC Payback Period
67. Calculate SaaS Quick Ratio
68. Identify Users at Risk of Churning
69. Calculate User Retention by Signup Cohort
70. Calculate Subscription Renewal Rate
71. Track Plan Distribution of Active Subscribers
72. Track Plan Upgrade and Downgrade Trends
73. Calculate Average Session Duration
74. Calculate MRR Growth Rate Month over Month
75. Track Free-to-Paid Upgrade Rate
76. Calculate Customer Health Score
77. Track Weekly Active Users (WAU)
78. Calculate Support Ticket Volume per Customer
79. Identify Power Users by Activity
80. Calculate Gross Margin by Month
81. Track API Usage by Customer
82. Calculate Lead Velocity Rate (LVR)
83. Track Signup Source Attribution
84. Calculate Monthly Burn Rate
85. Identify Dormant Accounts with Active Subscriptions
86. Track Invitation and Viral Growth
87. Calculate Expansion Revenue by Account
88. Calculate Average Time to Close a Deal
89. Calculate Revenue Concentration Risk
90. Track Onboarding Completion Rate
91. Calculate Average Seats per Account
92. Track Failed Payments and Involuntary Churn
93. Calculate Customer Effort Score (CES)
94. Track Product Qualified Leads (PQLs)
95. Calculate Monthly Active Teams
96. Calculate Revenue Run Rate
97. Track Cancellation Reasons
98. Calculate Daily Revenue
99. Calculate User Engagement Score
100. Track Cumulative MRR Growth
101. Track Churned Revenue by Plan