Tuesday, June 3, 2008

Agent Query

SELECT distinct agent FROM writers_market
WHERE accepting_solicitations = true AND
represented_genres in ('romance', 'contemporary romance', 'womens literature')
ORDER BY
average_advance DESCENDING,
response_time ASCENDING,
commission_pct ASCENDING


Sorry, couldn't resist. I've probably been at work too long...
(June 18: Updated the title to make a bit more sense with the joke. I know, I know, it's still only funny if you're a writing computer nerd....)

No comments: