With an original artist names Bette Midler, what is the order number?
CREATE TABLE table_24429 (
    "Week #" text,
    "Theme" text,
    "Song choice" text,
    "Original artist" text,
    "Order #" text,
    "Result" text
)
SELECT COUNT("Order #") FROM table_24429 WHERE "Original artist" = 'Bette Midler'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: With an original artist names Bette Midler, what is the order number? ### Input: CREATE TABLE table_24429 (
    "Week #" text,
    "Theme" text,
    "Song choice" text,
    "Original artist" text,
    "Order #" text,
    "Result" text
) ### Response: SELECT COUNT("Order #") FROM table_24429 WHERE "Original artist" = 'Bette Midler'