surrealdetective

count = 1
fizz = []
buzz = []
fizzbuzz = []
while count <= 50
  fizzbuzz.push(count) if count%3 == 0 && count%5 == 0
  fizz.push(count) if count%5 == 0 
  buzz.push(count) if count%3 == 0
  count +=1
end

surrealdetective

#Assignment.rb
#https://gist.github.com/aviflombaum/fd375100f4410dbbf184

# Write an expression that returns true by using ==
8*8 ==64

# Write an expression that returns false using ==
rand(10) == 11

# Write an expression that returns true using != Write an expression that returns false using !=

surrealdetective

--schema

CREATE TABLE projects (
  id int,
  title text,
  category text,
  funding_goal int
);

CREATE TABLE users (

surrealdetective

Answers
1. [email protected]
2. 1
3. Eight 
4. No really, wob!
5. [email protected]

surrealdetective

Questions:
1. What is the EmailAddress of the Host(s) with a 77021 ZipCode?
2. Which apartment would you prefer, PlaceID 1 or 6?
3. How many cities end in the 'ton'? 
4. How does the Host with [email protected] as an EmailAddress describe their place in their Description?
5.What is the EmailAddress of the person who has a phone number of 1231234123?

surrealdetective

CREATE TABLE Hosts (
  HostID int primary key,
	PlacesID int,
	EmailAddress varchar(100),
	PhoneNumber varchar(50),
	AddressLine1 varchar(100),
	AddressLine2 varchar(100),
	City varchar(100),
	Region varchar(50),
	ZipCode varchar(50),

surrealdetective

Name: Alex Au
Github Username: surrealdetective
Blog Url: surrealdetective.github.io 
Tagline: Do not not plan.
Profile Picture: http://www.gravatar.com/avatar/5bf486721d034a5b306c948614eb3415.png
Treehouse Account: http://teamtreehouse.com/alosaperau
CoderWall Account: https://coderwall.com/surrealdetective
CodeSchool Account: http://www.codeschool.com/users/alosaperau
Favorite Websites: www.hackeducation.com, www.atimes.com, www.mangahere.com
Previous Work Experience: Education Policy Analyst for National Council on Teacher Quality

surrealdetective

1. Remember table is tall and made out of wood
2. Remember plate is round has shortest height
3. Remember pb jar is round and has a cap and is brown on the inside. 
4. Remember jelly jar is round has a cap and is purple on the inside.
5. Remember loaf is brown, grainy, wrapped in plastic and sliced into square-like pieces.
6. Remember knife is shiny and share on the top half and dull on the bottom half. 
  /* Putting bread on plate */
7. Find the "twist-knot" that is part of the loaf and red
8. Grab each end of the twist-knot with a separate hand.
9. Proceed to unravel it by twisting the two ends such that each end slowly gets longer. If the two ends get shorter, then twist the two ends in the opposite direction.