Re: [sqlite] sqlite-users Digest, Vol 38, Issue 4

2011-02-04 Thread Igor Tandetnik
On 2/4/2011 11:14 AM, Scott Baker wrote: > On 02/04/2011 04:00 AM, sqlite-users-requ...@sqlite.org wrote: >> On 2/3/2011 12:10 PM, Scott Baker wrote: #3) Query for customers who bought exactly 2 apples? >> select CustomerID from Customers >> group by CustomerID >> having sum(Type = 'Apple')

Re: [sqlite] sqlite-users Digest, Vol 38, Issue 4

2011-02-04 Thread Scott Baker
On 02/04/2011 04:00 AM, sqlite-users-requ...@sqlite.org wrote: > On 2/3/2011 12:10 PM, Scott Baker wrote: >> > CREATE Table Customers ( >> >EntryID INTEGER PRIMARY KEY, >> >CustomerID INT, >> >Type ENUM >> > ); >> > >> > #1) Query for customers who*ONLY* bought apples > select Custo