Task: Text to Code
Input (English): Step 1: find the professional_id, last_name, home_phone of Professionals table for which state equals Indiana.
Step 2: find the number of rows of each value of professional_id in Professionals table.
Step 3: find professional_id, last_name, home_phone in Professionals table whose corresponding value in step 2 is greater than or equals 2.
Step 4: show the rows that are in any of the results of step 1 or the results of step 3
Output (English): SELECT professional_id , last_name , home_phone FROM Professionals WHERE state = "Indiana" UNION SELECT professional_id , last_name , home_phone FROM Professionals GROUP BY professional_id HAVING Count ( * ) > = 2