Task: Text to Code
Input (English): Step 1: find rows in customer table whose credit_score greater than 100.
Step 2: find each value of state in the results of step 1 along with the  no_of_loans of the corresponding rows to each value
Output (English): SELECT state , Sum ( no_of_loans ) FROM customer WHERE credit_score > 100 GROUP BY state