Task: Text to Code
Input (English): Step 1: find rows in university table whose Founded less than 1850.
Step 2: find each value of Affiliation the results of step 1 along with the number of the corresponding rows to each value
Output (English): SELECT Count ( * ) , Affiliation FROM university WHERE Founded < 1850 GROUP BY Affiliation