Comment by ecopoesis

I'm a software developer, but the code I work does a lot of DB access. I always ask a "two joins and an aggregate question."

Given three tables:

    authors     books       sales
    ----------  ----------  ----------
    id          id          id
    name        author_id   book_id
                title       date
                            price

find the total sales by author in November 2013. The result set should have two columns: author's name and their total sales.