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