Task: Text to Code
Input (English): Step 1: find the number of rows of each value of customer_id in Customers table.
Step 2: find customer_name, customer_email in Customers table whose corresponding value in step 1 is equals New.
Step 3: find customer_name, customer_address in Customers table whose corresponding value in step 1 is less than Pending.
Step 4: show the rows that are in both the results of step 2 and the results of step 4
Output (English): SELECT customer_name , customer_email FROM Customers GROUP BY customer_id HAVING Count ( * ) = "New" INTERSECT SELECT customer_name , customer_address FROM Customers GROUP BY customer_id HAVING Count ( * ) < "Pending"