After execution of the querySELECT Cname, COUNT (Make) AS COUNT1,COUNT (DISTINCT Make) AS COUNT2FROM RENTALSGROUP BY Cnamethe row that contains BLACK in the column Cname will have the following value in column COUNT1:CUSTOMER Channe BLACK GREEN JONES MARTIN SIMON VERNON xas Resid City ERIE CARY HEMET HEMET Birth Place TAMPA ERIE TANPA TAMPA ERIE CARY CARY Run 1 2 RENTALS Channe BLACK BLACK BLACK GREEN JONES JONES MARTIN SIMON WARP 4 Make Date O Pickup Return FORD 10-Oct-1994 CARY C ARY GM 0 1-Nov-1995 TAMBACARY FORD 01 Jan 1995 ERIE ERIE NISSAN074-1994 TAMPA ITAMPA FORD 01-Jul-1995 CARY TERIE GM 01-Aug-1995 ERIE ERIE FORD 01-Anag-1994 CARY ERIE 01-Sep-1995 ERIE CARY TOYOTA 02-Sep-1995 RENO R ENO GM 3
