Skip to content
Permalink
 
 
Cannot retrieve contributors at this time
26 lines (11 sloc) 713 Bytes

JOIN fun with SF inspection data

Inner join exercises

(to do in class)

Find all violations by the In-N-Out Burger

Get a list of all vermin-type violations (no JOIN needed)

Get a list of all inspections that have had a vermin-type violation

Get a list of all restaurant names that have had a vermin-type violation

What is the dirtiest-rated Starbucks/McDonalds/Peet's/etc?

You can’t perform that action at this time.