user: ### NOW ANSWER:
Question: What was the rank (week) for episode number 34?
Columns: ['No.', '#', 'Title', 'Directed by', 'Written by', 'U.S. viewers (million)', 'Rank (week)', 'Original air date', 'Production code']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [14.0, 1.0, '" Change of Station "', 'Steven DePaul', 'David Mamet', '11.8', 'N/A', 'September19,2006', '2ALF01']
SQL:

assistant: SELECT "Rank (week)" FROM "Table" WHERE "No." = 34.0;