user: Question: What is the rank of the film directed by kevin costner?
Columns: ['Rank', 'Title', 'Studio', 'Director', 'Gross']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'Ghost', 'Paramount', 'Jerry Zucker', '$505,702,588']
SQL:

assistant: SELECT "Rank" FROM "Table" WHERE "Director" = 'kevin costner';