opus title genre sub­divisions libretto composition premiere date place, theatre
opus
title
genre
subdivisions
libretto
composition
première date
place , theatre
first second first_number
minimum_number minimum_parsed minimum_year maximum_number maximum_parsed maximum_year
list length list_number list_parsed list_year list_month list_day
address
number(text) text text text text timespan <s,date> address
60 (ii) der kampf mit dem drachen singgedicht 1 act theodor korner 1876 10 may 1894;
revised version: 29 october 1940 unperformed
which composition spanned a longer period from beginning of composition to premiere - elektra , or intermezzo ?
WDT NN VBD DT JJR NN IN NN IN NN TO VB : NNP , CC NNP .
Intermezzo
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Literal.String Keyword Literal.String Keyword Keyword Keyword Column Keyword Column Keyword Keyword Keyword
select c2 from w where c2 in ( 'elektra' , 'intermezzo' ) order by c7_list_year - c6_minimum_year desc limit 1
None Column None None Keyword None Keyword Column Column Column Keyword Column None Literal None Keyword Literal None
c2 ['sort', 'sort_desc'] ['before', 'before_minus'] c7_list_year c7_list_year c7_list_year ['before', 'before_minus'] c6_minimum_year ['conj', 'conj_or']