Skip to content

a long, random walk…

… because life is long, and change is random

  • Home
  • Mid-Career Tech
  • Democratizing Data
  • The Sewist’s Station
  • The Straight Dope

Tag: aggregate

Mid-Career Tech

Aggregating metrics: Using “GROUP BY”

August 31, 2020September 12, 2020 Hwei Yi comment on Aggregating metrics: Using “GROUP BY”

Earlier, we’ve discussed that your database stores data at its most granular level. This means that every order creates one row in your orders table. Likewise, every click a customer makes creates one row in your clicks table. And every review you receive creates one row in your product reviews table. When this builds up

Continue Reading ..

ABOUT ME

Many random walks brought me here. A penchant for travel landed me into the world of e-commerce and analytics. My mum’s long-forgotten Burda magazines inspired me to become a sewist. If you are walking on any of these paths, I want to walk with you and share the things I have learned.

Links to the "Survival SQL" series.

Recent Posts

  • Camino Training Ep.1 – First Camino Diaries Pt 2
  • First Camino Diaries Pt 1: Planning From Ground Up
  • Mask Fit Demo: Olson vs. TAFF
  • Mask-Making Vlog: What I learned from making 900+ masks in the COVID-19 era
  • Budget Beginner’s Tutorials Sample Project – Making Shepherd’s Pie Short

Archives

  • December 2023
  • November 2023
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020

© 2025 a long, random walk…

Proudly powered by WordPress | Theme: x-blog-lite by wpthemespace.com