设数据库基本表：movie（title,year,length,incolor,studioname,producerc#）请用SQL语句写出哪些电影比乱世佳人（ganewiththewind）更长?

Question

设数据库基本表：
movie（title,year,length,incolor,studioname,producerc#）
请用SQL语句写出哪些电影比 乱世佳人 （gane with the wind）更长?

Answer 1

select * from movie where length>(select length from movie where title='gane with the wind')