Friday, March 02, 2012


I learned to write some very basic SQL today using the SELECT statement to choose columns and rows for display, the COUNT function to aggregate data, and the GROUP BY statement to group things.  For more practice, I could apply this in my personal life with a grocery list to my husband.  How about this?
SELECT Item, Quantity, Aisle FROM Grocery_List WHERE Store = ‘Costco’ ORDER BY Item. 
 I would get a list like this:

Fortunately, John is not a database I have to query so I can just ask him in plain English (though sometimes that's not always effective either ;-P).

No comments: