Thursday August 18, 2005
Smashup: SQL for the "Real World"
Excerpts from the new smashup "SQL for the 'Real World'"
Part of O'Reily's "Add some geek to your cool" series.
Lesson 1
Goal: Introducing the use of _ and '' into everyday language
Select clothes from stores where cool_friends like 'to shop'
Lesson 2
Goal: Introducing the use of = and capitalization
SELECT cheeseburger FROM menu WHERE fast_food_chain='Sonic' ORDER BY drive_thru_window
Lesson 3
Goal: Introducing the use of . () and >
UPDATE your.morals_with VALUES('bling','cool','hot') WHERE your.living='on_your_own'
AND your.age > 18 AND your.opinion_is LIKE 'totally'
Lesson 4
Goal: Putting it all together
SELECT guy AS boyfriend, SUM(bank_accounts) AS bling FROM club_scene WHERE body='hot' AND peers_say='he''s cool' GROUP BY boyfriend HAVING bling > 100,000
Note to self: Watching Pauly Shore's Minding the Store is not advancing your skilz. (2005-08-18 07:08:25.0)
Permalink
Comments [0]
