Eric Milford :: Web Developer & Food Advocate

I sat under a street light along 8th Avenue at 14th Street reading A Confederacy of Dunces. It was nearly 3AM on a near-perfect night. These are my favorite hours of the day; peaceful, reflective. The small, normally unnoticed details suddenly standout. The building across the street, with its broad front and many columns of windows, reminds me of Bonn. In the upper corner read Steak House. The horns of impatient cab drivers are more frustrating at this hour and a man near me plays thumb drums on the table. His rhythm is horribly off.

An older man pulled from his cigarette and asked how I read here at this hour. I could have done without the small talk, but still politely entertained his question. His finger pointed out to a bar on the street corner as he let me in on a little secret. He stared at me as if to suggest I head there now. I had on gym shorts and sneakers, not to mention no desire for the sort. A group of women walked out. The man obnoxiously let out a cat call from across the street. I wondered if such tactics had ever worked. For any man, anywhere. I think I know the answer. He said in parting that he preferred reading to jazz. At that moment I, quite frankly, could care less. I continued reading.

I passed a homeless man on my walk home. He was hunched over asleep. His cart of belongings was covered in American flags. I could feel his pride. I wanted to ask his story, but continued walking. I enjoy talking to people; our lives, I find, are often so interesting. Perhaps another time.

I was asked recently to write the SQL needed to define a class method named User.busy? that would return an array of User records with a post count greater than or equal to 2.

Let's assume we have two tables, users and posts, linked by the primary key users.id and the foreign key posts.user_id.

I knew high level that I would need a join between the two tables and some way to apply a where clause on the count of posts grouped by users. A quick bit of research introduced me to the group by plus having technique.

1 select users.* from users join posts on posts.user_id = users.id group by posts.user_id having count(*) >= 2

Ta da!