Skip to content

Instantly share code, notes, and snippets.

View augescens's full-sized avatar

Josh augescens

View GitHub Profile
@augescens
augescens / frequency_example_with_subqueries.sql
Last active August 29, 2015 14:01
Example frequency report for "Writing Analytics SQL with Common Table Expressions."
/*
Copyright 2014 Neustar, Inc.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
@augescens
augescens / frequency_example_with_CTEs.sql
Last active July 5, 2016 18:54
Example frequency report for "Writing Analytics SQL with Common Table Expressions" blog post
/*
Copyright 2014 Neustar, Inc.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software