Skip to content

Instantly share code, notes, and snippets.

@florentroques

florentroques/sql reminders.md

Created April 9, 2016 18:35
Show Gist options
  • Save florentroques/8eb754dae95c57cd34d8333e92e07dc3 to your computer and use it in GitHub Desktop.
Save florentroques/8eb754dae95c57cd34d8333e92e07dc3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql reminders.md
  • Data aggregation is the grouping of data in summary form.
  • Daily Count is the count of orders in a day.
  • Daily Revenue Count is the revenue on orders per day.
  • Product Sum is the total revenue of a product.
  • Subqueries can be used to perform complicated calculations and create filtered or aggregate tables on the fly.
  • Reorder Rate is the ratio of the total number of orders to the number of people making orders.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment