Modify the SQL statement to: Add the State field to the SELECT The State field should appear before the COUNT(ParentID) function. Group the records by the State Sort the records by the State field in...

Modify the SQL statement to:

1. Add the
   State
   field to the
   SELECT
   The
   State
   field should appear before the COUNT(ParentID) function.


2. 
   Group
   the records by the
   State
   


3. 
   Sort
   the records by the
   State
   field in
   Ascending
   

Given SQL:

SELECT Count(ParentID) AS NumberParents
FROM Parent;