--bcaec5396a686c46a404bf996974
Content-Type: text/plain; charset=ISO-8859-1
I have a table called club_members. It has 3 columns
first_name,last_name,club_name
Write a query to summarize how many clubs each student is in. The Dean
wants a concise report so consolidate it to show just the count of students
based on the number of clubs they are in.
*Sample report* (your numbers and basic styling may differ)
students, clubs_per_student
600, 0
300, 1
200, 2
...
I have tried and cannot get a handle around this one. Any help would be
greatly appreciated.
Thanks,
floyd
Floyd Wellershaus
Dba/Sa Informix/Oracle/Linux/Aix
http://www.linkedin.com/in/floydwellershaus
http://photos.fwellers.com
========================================================
--bcaec5396a686c46a404bf996974
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
ame,club_name</div><div><br></div><div><p class=3D"MsoNormal"><span style=
=3D"font-size:12.0pt;line-height:115%;font-family:"Arial","s=
ans-serif"">Write a query to summarize how many clubs each student is
in.=A0 The Dean wants a concise report so
consolidate it to show just the count of students based on the number of cl=
ubs
they are in.</span></p>
ze:12.0pt;line-height:115%;font-family:"Arial","sans-serif&q=
uot;">Sample report</span></u><span style=3D"font-size:12.0pt;line-height:1=
15%;font-family:"Arial","sans-serif"">
(your numbers and basic styling may differ)</span></p>
12.0pt;line-height:115%;font-family:"Arial","sans-serif"=
;">students, clubs_per_student</span></p>
12.0pt;line-height:115%;font-family:"Arial","sans-serif"=
;">600, 0</span></p>
12.0pt;line-height:115%;font-family:"Arial","sans-serif"=
;">300, 1</span></p>
12.0pt;line-height:115%;font-family:"Arial","sans-serif"=
;">200, 2</span></p>
12.0pt;line-height:115%;font-family:"Arial","sans-serif"=
;">...</span></p><p class=3D"MsoNormal" style=3D"margin-left:.5in"><font fa=
ce=3D"Arial, sans-serif" size=3D"3"><span style=3D"line-height:18px"><br>
is one. Any help would be greatly appreciated.<div><br></div><div>Thanks,</=
div><div>floyd</div><div><br><div><br></div><div><br clear=3D"all">Floyd We=
llershaus<br>
Dba/Sa Informix/Oracle/Linux/Aix<br><br><a href=3D"http://www.linkedin.com/=
in/floydwellershaus" title=3D"View public profile" name=3D"SafeHtmlFilter_w=
ebProfileURL" style=3D"margin-top:0px;margin-right:0px;margin-bottom:0px;ma=
rgin-left:0px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-=
left:0px;border-top-width:0px;border-right-width:0px;border-bottom-width:0p=
x;border-left-width:0px;border-style:initial;border-color:initial;outline-w=
idth:initial;outline-style:none;outline-color:initial;font-size:13px;font-f=
amily:Arial,Helvetica,'Nimbus Sans L',sans-serif;vertical-align:bas=
eline;text-decoration:none;color:rgb(0,102,153);line-height:15px;background=
-color:rgb(255,255,255)" target=3D"_blank">http://www.linkedin.com/in/floyd=
wellershaus</a>=A0<br>
llers.com</a><br>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br>
--bcaec5396a686c46a404bf996974--