dankohn

SELECT
  repo_name AS repository,
  EXACT_COUNT_DISTINCT(author.name) AS authors,
  EXACT_COUNT_DISTINCT(committer.name) AS committers,
  COUNT(*) AS commits
FROM
  [bigquery-public-data:github_repos.commits]
WHERE
  committer.date >= TIMESTAMP("2016-01-01 00:00:00")
  AND committer.date < TIMESTAMP("2017-01-01 00:00:00")

dankohn

SELECT
  repo_name AS repository,
  EXACT_COUNT_DISTINCT(author.name) AS authors,
  EXACT_COUNT_DISTINCT(committer.name) AS committers,
  COUNT(*) AS commits
FROM
  [bigquery-public-data:github_repos.commits]
WHERE
  repo_name IN ( "torvalds/linux",
    "facebook/react-native",

dankohn

SELECT
  repo.name AS repository,
  COUNT(repo.name) AS commits,
  EXACT_COUNT_DISTINCT(actor.login) AS committers,
  EXACT_COUNT_DISTINCT(JSON_EXTRACT(payload, '$.commits[0].author.email')) AS authors
FROM
  [githubarchive:year.2016]
WHERE
  type IN ("PushEvent")
GROUP BY

dankohn

# frozen_string_literal: true

class Server
  def get(query)
    respond "db: #{@db}"
    return unless (value = query['key'])
    if (lookup = @db[value])
      respond "successful lookup: #{value} => #{lookup}"
    else respond "failed lookup: no entry for #{value}"
    end

dankohn

                                                OOOO                                                
                                             OOOOOOOOOO                                             
                                           ZZOOOOOOOOOOO                                            
                                          ZZZZZOOOOOOOOOOO                                          
                                        ZZZZZZZZZOOOOOOOOOO                                         
                                       ZZZZZZZZZZZOOOOOOOOOOO      $$$$$$                           
                                     ZZZZZZZZZZZZZZZOOOOOOOOOOO   $$$$$$$$$                         
                                   ZZZZZZZZZZZZZZZZZZOOOOOOOOOOO$$$$$$$$$$$$$                       
                                  ZZZZZZZZZZZZZZZZZZ    ~OOOOOOMMM$$$$$$$$$$$$                      

dankohn

puts 1.upto(100).map { |n| "#{'Fizz' if n%3==0}#{'Buzz' if n%5==0}".presence || n }