Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
SQL

SQL: Use Aggregate Functions for Data Analysis

- 05.07.26 - ErcanOPAK

📊 Aggregate Functions = Data Insights

Need totals, averages, counts? Aggregate functions summarize data. Essential for reporting and analytics.

📝 Basic Aggregates

SELECT 
    COUNT(*) AS total_rows,
    COUNT(DISTINCT column) AS distinct_values,
    SUM(amount) AS total_sum,
    AVG(amount) AS average,
    MIN(amount) AS min_value,
    MAX(amount) AS max_value,
    STDDEV(amount) AS std_dev
FROM orders;

-- With GROUP BY
SELECT 
    customer_id,
    COUNT(*) AS order_count,
    SUM(total) AS total_spent,
    AVG(total) AS avg_order_value
FROM orders
GROUP BY customer_id
ORDER BY total_spent DESC;

-- With HAVING (filter groups)
SELECT 
    customer_id,
    COUNT(*) AS order_count,
    SUM(total) AS total_spent
FROM orders
GROUP BY customer_id
HAVING COUNT(*) > 5 AND SUM(total) > 1000;

🎯 Analytical Queries

-- Monthly sales summary
SELECT 
    DATE_TRUNC('month', order_date) AS month,
    COUNT(*) AS order_count,
    SUM(total) AS revenue,
    AVG(total) AS avg_order_value,
    MIN(total) AS min_order,
    MAX(total) AS max_order
FROM orders
WHERE order_date >= '2024-01-01'
GROUP BY DATE_TRUNC('month', order_date)
ORDER BY month;

-- Product performance
SELECT 
    p.name AS product_name,
    COUNT(oi.product_id) AS times_ordered,
    SUM(oi.quantity) AS total_units_sold,
    SUM(oi.quantity * oi.price) AS total_revenue
FROM products p
JOIN order_items oi ON p.id = oi.product_id
GROUP BY p.id, p.name
HAVING COUNT(oi.product_id) > 0
ORDER BY total_revenue DESC;

-- Customer segmentation
SELECT 
    CASE 
        WHEN total_spent > 10000 THEN 'Premium'
        WHEN total_spent > 1000 THEN 'VIP'
        WHEN total_spent > 100 THEN 'Regular'
        ELSE 'Basic'
    END AS segment,
    COUNT(*) AS customer_count,
    SUM(total_spent) AS total_revenue,
    AVG(total_spent) AS avg_spent
FROM (
    SELECT 
        customer_id,
        SUM(total) AS total_spent
    FROM orders
    GROUP BY customer_id
) AS customer_spending
GROUP BY segment;

💡 Aggregate Tips

  • COUNT(*) counts all rows
  • COUNT(column) counts non-null values
  • DISTINCT removes duplicates
  • NULL values are ignored in AVG, SUM, etc.
  • Use HAVING for group filtering

“Aggregate functions summarize data. Totals, averages, counts — all in one query. Essential for analytics.”

— Data Analyst

Related posts:

How to use OUTPUT for Insert, Update and Delete in SQL

How to use OUTPUT for Insert, Update and Delete in SQL

Drag and Drop objects from Object Explorer to the Query Window in SQL Server

Drag and Drop objects from Object Explorer to the Query Window in SQL Server

Search text in all tables in SQL Server

Search text in all tables in SQL Server

Views: 20

Post navigation

.NET Core: Use Dependency Injection for Loose Coupling
C#: Use LINQ to Query Collections Efficiently

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (653)
  • Add Constraint to SQL Table to ensure email contains @ (609)
  • Average of all values in a column that are not zero in SQL (570)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (547)
  • Find numbers with more than two decimal places in SQL (475)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com