Sql using excel and access database queries

10) Paste in the following code that is similar to the code in the middle of page 371 from the text into the "Command text" area of the "Connection Properties" dialog box and click "OK." SELECT Gender, COUNT(*) as numcusts, FROM Customers GROUP BY Gender 11) Modify the above SQL code so that it generates three columns - the gender, number of customers, and number of households. The query should return three rows of data. Each of the three rows should contain summary data for the three gender values: "Not Specified," "F," and "M." (You will have to add "Not Specified" to you tabije as a value for gender after the query.) Next, display the results in a column chart. And change the chart title to "Household Gender" and place it to the right of the table of query results. The chart should show two columns for each gender - one for number of customers and one for number of households. Orders x III Customers x III ZipCensus x \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline coderid - & customend A & Campaignid - & orderdate - & aty & state. & zipcode & paymenttype & * totalprice . & numorderlines & * \\ \hline 1002444 & 0 & 2204 & 1/12/2011 & AUCKLAND & & 0 & vi & 10 & & 1 \\ \hline 1002656 & 203172 & 2141 & 6/2/2011 & MIAMI & F & 33177 & AE & 35,22 & & 2 \\ \hline 1003494 & 103152 & 2141 & 11/22/2010 & EAST QUOGUE & NY & 11942 & MC & 36 & & 1 \\ \hline 1003273 & 104468 & 2173 & 4/9/2010 & LONG ISLAND & NY & 11105 & VI & 24.95 & & 2 \\ \hline 1003077 & 104565 & 2173 & 11/22/2010 & SANTAFE & NM & tysos & MC & 24.55 & & 2 \\ \hline 1003548 & 10477 & 217 & 11/21/2010 & BLOMFIELD & NY & 14463 & AE & 10 & & 1 \\ \hline 1003490 & 104796 & 2141 & 2/15/2011 & LUVENGSTON & Nu & 7039 & Dat & 0 & & 1 \\ \hline 1002887 & 106180 & 217 & 16/15/2009 & FWWAYTON & CT & 6953 & AL & 10 & & 1 \\ \hline 2003756 & 106151 & 2173 & 11/23/2010 & o POUGHKEFPSA & ENY & 12603 & MC & 30 & & 1 \\ \hline 1003978 & 106152 & 2141 & 11/23/2010 & O NEW YORX & NY & 10017 & OC & 45 & & 1 \\ \hline 1002445 & 105178 & 2141 & 2/6/2011 & 1 PASABINA & CA & 91104 & VI & 40.5 & & 1 \\ \hline 100.040 & 10461 & 2173 & 10/15/2009 & 9 ROSLYN & NY & 11576 & MC & 20 & & 1 \\ \hline 1001039 & 107327 & 2141 & 10/15/2009 & 9 SALFM I & MA & 1970 & AE. & 185 & & 2 \\ \hline 1002443 & 10772 & 2173 & 1/12/2011 & 1 REDMOND & WA & SE05? & AE & 10 & & 1 \\ \hline 1002298 & 107832 & 2236 & 1/12/2011 & 1 OAERIOY IULL & NI & 8003 & AE: & 22.5 & & 1 \\ \hline 1003753 & 107887 & 2141 & 11/22/2010 & O SAN ANTONIO & 1x & 78209 & MC & 18 & & 1 \\ \hline 1003754 & 107858 & 2171 & 11/221/2010 & 0 NEW YORK & Ny & 10010 & AE & 225 & & 1 \\ \hline 1003152 & 107289 & 2173 & 4/6/2010 & D GUITH NBEAG & NI & 2093 & Di & 19.6 & & 1 \\ \hline 1003189 & 107980 & 2141 & 4/4/2010 & D. PHOENIX & AZ & 05002 & VI & & & 1 \\ \hline 1003/24 & 100423 & 2141 & 11/23/2010 & 9. EASTHAMPTO & MNY & 11537 & vi & 18 & & 1 \\ \hline 1003549 & 109424 & 2173 & 11/22/2010 & GREATNECK & Nr & 11023 & vi & 10 & & 1 \\ \hline 1002450 & 109119 & 2173 & 1/12/2011 & 1 MONMOUTH A & H NI & 7750 & VI & 30 & & 1 \\ \hline 1003496 & 109144 & 2173 & 11/22/2010 & HONOtutu & AI & 96825 & OC & 30 & & 1 \\ \hline 1002113: & 105558: & 217 & 4/6/2010 & FORESTEUAGH & +Nr & 1277 & DE & 15 & & 1 \\ \hline 1003979 & 110061 & 2141 & 11/21/2010 & WESTWOOD & Ni & 7675 & AE & is & & 2 \\ \hline 1003624 & 110715 & 2141 & 11/21/2010 & 2 PALOALTO & CA & 94100 & Vi & 225 & & 1 \\ \hline 1001/21 & 110960 & 2035 & 11/23/2010 & S HORAL PAIK & NY & 11001 & VI & 19.12 & & 1 \\ \hline 1003155 & 111819 & 2173 & 4/7/2010 & HOUSTION & IX & 70027 & ME & 195 & & 1 \\ \hline-2003007 & 114363 & 2141 & 1/13/2010 & 0. wruester & MA & 2452 & DE & 19.63 & & 1 \\ \hline 2002297 & 114650 & 2173 & 1/12/2011 & 1 IMACA & NY & 14as0 & MiC & 22.5 & & 1. \\ \hline 1002447 & 114651 & 2141 & 1/12/2011 & 1 HAWTHOANE & NI & 7506 & VI & 10 & & 1 \\ \hline 1002446 & 12163 & 2141 & 1/12/2011 & 1 NEW YORK & for & 10028 & MC & 20.25 & & 1 \\ \hline 1003153 & 124124 & 2173 & 4/6/2010 & D YAKAMA & WA & & 00 & 205 & & ? \\ \hline 1003771 & 124417 & 2173 & 4/17/2010 & WANEAS CITY & MO & 64106 & De & 0 & & 1 \\ \hline 1003910 & 124437 & 217 & 11/22/2010 & MCMPES & IN & 13103 & AE & 39,36 & & 1 \\ \hline 1002355 & 125301 & 217 & 10/13/2009 & NEW HOCHEUI & INY & 10804 & VI & 10 & & 1 \\ \hline 1002449 & 126120 & 2141 & 1/12/2011 & 1 HISA & OK & 74136 & AL & 20.25 & & 1 \\ \hline 1002554 & 126171 & 2216 & 1/12/2011 & 1 HOUSTON & Ix & 7056 & MC & 15.01 & & \\ \hline \end{tabular}