user: ### NOW ANSWER:
Question: With an original artist names Bette Midler, what is the order number?
Columns: ['Week #', 'Theme', 'Song choice', 'Original artist', 'Order #', 'Result']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Audition', 'N/A', '" All I Do "', 'Stevie Wonder', 'N/A', 'Advanced']
SQL:

assistant: SELECT COUNT("Order #") FROM "Table" WHERE "Original artist" = 'Bette Midler';