Table: titles_translated
Columns: english_title
russian_title
published_in_russian
published_in_english
type_of_work

Question: when type of work is novel and published in english is 1977, what was published in russian?
SQL: SELECT "published_in_russian" FROM titles_translated WHERE "type_of_work" = 'novel' AND "published_in_english" = '1977'

Question: How many types of work is хромая судьба?
SQL: SELECT COUNT("type_of_work") FROM titles_translated WHERE "russian_title" = 'Хромая судьба'

Question: What is the russian title of the ugly swans?
SQL: SELECT "russian_title" FROM titles_translated WHERE "english_title" = 'The Ugly Swans'

Question: when it published in english is n/a and published in russian is 1986, what is the type of work?
SQL: SELECT "type_of_work" FROM titles_translated WHERE "published_in_english" = 'N/A' AND "published_in_russian" = '1986'