human
Schema:
book_club (book_club_id, Year, Author_or_Editor, Book_Title, Publisher, Category, Result)
movie (movie_id, Title, Year, Director, Budget_million, Gross_worldwide)
culture_company (Company_name, Type, Incorporated_in, Group_Equity_Shareholding, book_club_id, movie_id)
Please answer with SQL.
assistant
Sure, I understand.
human
Are there any other categories? | Do you mean the other category has books after year 1989? Gay SF/F is the only one category has books after year 1989 | Yes, that's what I meant. How many books does Gay SF/F have after 1989?
assistant
SELECT COUNT( * ) FROM book_club WHERE Category = "Gay SF/F" AND year > "1989" ;