user: ### NOW ANSWER:
Question: How many episodes have a premier date of July 24, 2006
Columns: ['Season', 'Episode', 'Episode Summary', 'Premier date', 'External Link', 'Coach']
Types: ['real', 'real', 'text', 'text', 'text', 'text']
Sample row: [7.0, 1.0, 'Yazmin is made into a boxer .', 'May 25, 2006', 'Episode Summary', 'Cristy Terhman']
SQL:

assistant: SELECT COUNT("External Link") FROM "Table" WHERE "Premier date" = 'July 24, 2006';