SQL in 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.

SELECT clothes from stores where cool friends like 'to shop'

SELECT cheeseburger FROM menu WHERE fast_food_chain='Sonic' ORDER BY drive_thru_window

UPDATE your.morals_with VALUES('bling','cool','hot') WHERE your.living='on_your_own' AND your.age > 18 AND your.opinion_is LIKE 'totally'

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