Question: More SQL help. Data in the table donor: IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL CONTACT 500 John Smith 400 Susan Jones Seekonk MA
More SQL help.
Data in the table donor: IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL CONTACT 500 John Smith 400 Susan Jones Seekonk MA 02345 03-JUL-98 12121 Jennifer Ames 24 Benefit St Providence RI 02045 24-MAY-97 24 Benefit St Providence RI 02045 03-JAN-98 Fall River MA 02720 04-MAR-92 Fall River MA 02720 04-MAR-92 Fall River MA 02720 04-APR-98 22222 Carl Hersey 23456 Susan Ash Susan Jones 21 Main St 33333 Nancy Taylor 26 Oak St 34567 Robert Brooks 36 Pine St 100 Amy Costa 50 John Adams 50 Amy Costa Problem #4 : Show the results of the query below and explain your answer. Use the donor table. SQL> select contact, count() 2 from donor 3 group by contact 4 order by contact
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
