Task: Text to Code
Input (English): SQL: SELECT Count ( * ) , Brand FROM Medication GROUP BY Brand
Feedback: It should corresponds to number of rows of each value of medication medication in prescribes table .
Output (English): SELECT count(*) ,  T1.name FROM medication AS T1 JOIN prescribes AS T2 ON T1.code = T2.medication GROUP BY T1.brand