Oren Bochman OrenBochman

[SQL Fiddle][1]

MySQL 5.6 Schema Setup:

-- schema
CREATE TABLE Client (
    ClientId INT         NOT NULL AUTO_INCREMENT,
    ClientName VARCHAR(35)     NOT NULL,
    Email varchar(100)   NOT NULL,

PhoneNumber VARCHAR(11),

Delete all containers
```
 $ docker ps -q -a | xargs docker rm
```

-q prints only the container IDs -a prints all containers

Notice that it uses xargs to issue a remove container command for each container ID

Delete all untagged images

	---
	title: '# Chapter 1: Discrete Case: Multinomial Bayesian Networks'
	output:
	html_document: default
	html_notebook:
	number_sections: yes
	toc: yes
	---

	This R note book is my an annotated version of the code supplied with the first chapter of

	---
	title: "R Notebook"
	output:
	html_notebook:
	fig_caption: yes
	toc: yes
	---


	```{r setup}

	CREATE TABLE DIMENSIONS
	([Campaign] varchar(1), [Device] varchar(1), [Date] date)
	;

	INSERT INTO DIMENSIONS
	([Campaign], [Device], [Date])
	VALUES
	('A', 'M', '2017-10-07'),
	('A', 'D', '2017-10-07'),
	('A', 'T', '2017-10-07'),

	#!/bin/bash

	## Assuming Linux Mint 18. Should also mostly work with Ubuntu 16.04

	## Installing .deb packages could be done in a single go if I added the
	## necessary repositories beforehand but this way the script is more
	## modular and I can comment out any sections if I want to.

	## TODO: install Prey
	## TODO: Rewrite this with Salt/Ansible?

	<!DOCTYPE html>
	<html>

	<head>
	<meta charset="utf-8" />
	<meta name="description" content="[lovefield demo]">
	<meta name="viewport" content="width=device-width">
	<script src="https://unpkg.com/@reactivex/[email protected]/dist/global/Rx.js"></script>
	<script src="https://unpkg.com/lovefield"></script>
	<script src="https://unpkg.com/blockly"></script>

	# coding=utf8

	import PIL
	from PIL import ImageFont
	from PIL import Image
	from PIL import ImageDraw

	def text2png(text, fullpath, color = "#000", bgcolor = "#FFF", fontfullpath = None, fontsize = 13, leftpadding = 3, rightpadding = 3, width = 200):
	REPLACEMENT_CHARACTER = u'\uFFFD'
	NEWLINE_REPLACEMENT_STRING = ' ' + REPLACEMENT_CHARACTER + ' '

	import java.util.concurrent.Semaphore;
	import static org.junit.jupiter.api.Assertions.assertEquals;

	import org.junit.jupiter.api.DisplayName;
	import org.junit.jupiter.api.RepeatedTest;
	import org.junit.jupiter.api.Test;

	@DisplayName("Little book of semaphores - Rendevous")
	class Rendevous extends Thread {

	SELECT
	hits.page.pagePath
	FROM
	'bigquery-public-data.google_analytics_sample.ga_sessions_20160801' AS GA,
	UNNEST(GA.hits) AS hits
	GROUP BY
	hits.page.pagePath