Task: Text to Code
Input (English): Step 1: find the number of rows of each value of contestant_name in CONTESTANTS table.
Step 2: find contestant_number, contestant_name in CONTESTANTS table whose corresponding value in step 1 is greater than or equals 2
Output (English): SELECT contestant_number , contestant_name FROM CONTESTANTS GROUP BY contestant_name HAVING Count ( * ) > = 2