Skip to content

Instantly share code, notes, and snippets.

Peek SQL Code Challenge Submission

Applicant Name

[your name here]

Additional Information You Would Seek Out

There are many ways of modeling and approaching this problem, and there are many unknown factors that could determine which approach is better. Please list additional factors/information you would seek out.

SQL take-home challenge

drawing

Expected Time & Effort

We don't want you to have to take too much time with this challenge and ask that you do not spend more than 4 hours.

Challenge Overview

module Timber
module LogDevices
# A highly efficient log device that buffers and delivers log messages over HTTPS to
# the Timber API. It uses batches, keep-alive connections, and msgpack to deliver logs with
# high-throughput and little overhead.
#
# See {#initialize} for options and more details.
class HTTP
# @private
class LogMsgQueue
@mcivorsteiner
mcivorsteiner / yelp_example_job_request_payload.json
Last active April 21, 2016 01:56
Yelp Example Job Request Payload
{
"businesses" : [
{
"matching_criteria": {
"name" : "Avital Food Tours",
"phone" : "4153554044",
"address1" : "3543 18th St",
"address2" : null,
"address3" : null,
"city" : "San Francisco",
@mcivorsteiner
mcivorsteiner / jquery_example.html
Last active August 29, 2015 13:57 — forked from dbc-challenges/jquery_example.html
Intro to jQuery for Phase 0
<!DOCTYPE html>
<html>
<head>
<title>DOM manipulation with jQuery</title>
<!-- Add a link to jQuery CDN here script here -->
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
<script type="text/javascript" src="jquery_example.js"></script>
</head>
@mcivorsteiner
mcivorsteiner / 0.2.1-boggle_class_from_methods.rb
Last active January 4, 2016 04:29 — forked from dbc-challenges/0.2.1-boggle_class_from_methods.rb
phase 0 unit 2 week 1boggle class challenge
class BoggleBoard
attr_reader :board
def initialize(board)
@board = board
end
def create_word(*coords)
coords.map { |coord| @board[coord.first][coord.last]}.join("")
end