Table: yoshiura_works
Columns: year
name
genre
status
post

Question: Which Genre has a Year before 2013, and a Name of kikumana?
SQL: SELECT "genre" FROM yoshiura_works WHERE "year" < 2013 AND "name" = 'kikumana'

Question: In what year has a Post of designer?
SQL: SELECT SUM("year") FROM yoshiura_works WHERE "post" = 'designer'