Please help me! clarify the answer Second: What would be produced? Illustrate and explain (data shown below).SQL SELECT name, yrgoal, contamt2 FROM donor, donation3 WHERE donor.idno = donation.idno AND contamt > yrgoal/12;Donor tableIDNONAMESTADRCITYST ZIPDATEFSTYRGOAL CONTACT11111 Stephen Daniels 123 Elm St12121 Jennifer AmesMA 02345 03-JUL-98Providence RI 02045 24-MAY-97Seekonk500 John Smith24 Benefit St400 Susan Jones22222 Carl Hersey24 Benefit StProvidence RI 02045 03-JAN-98Susan Jones23456 Susan Ash21 Main StFall River MA 02720 04-MAR-92100 Amy Costa50 John Adams33333 Nancy Taylor26 Oak StFall River MA 02720 04-MAR-9234567 Robert Brooks36 Pine StFall River MA 02720 04-APR-9850 Amy CostaDonation table (note that dri is actually driveno)IDNO DRI CONTDATECONTAMT11111 100 07-JAN-992511111 200 12-JUN-993512121 200 23-FEB-994012121 100 04-JUN-995022222 100 14-MAR-991023456 100 03-MAR-992023456 300 14-JUN-991033333 300 10-MAR-9910Drive table (note that dri is actually driveno)DRI DRIVENAMEDRIVECHAIRLASTYEARTHISYEAR100 Kids ShelterAnn Smith10000200 Animal HomeLinda Grant5000300 Health AidDavid Ross7000400 Half WayRobert Doe

Given are two tables, Donor table and Donation table. Donor table has attributes idno, name, stadr,…

SQL SELECT name, yrgoal, contamt 2 FROM donor, donation 3 WHERE donor.idno = donation.idno AND contamt > yrgoal/12; Donor table IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL CONTACT 11111 Stephen Daniels 123 Elm St 24 Benefit St 24 Benefit St 21 Main St 26 Oak St 36 Pine St Seekonk Providence RI 02045 24-MAY-97 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 MA 02345 03-JUL-98 500 John Smith 12121 Jennifer Ames 400 Susan Jones 22222 Carl Hersey Susan Jones 23456 Susan Ash 33333 Nancy Taylor 100 Amy Costa 50 John Adams 34567 Robert Brooks 50 Amy Costa Donation table (note that dri is actually driveno) IDNO DRI CONTDATE CONTAMT 11111 100 07-JAN-99 11111 200 12-JUN-99 12121 200 23-FEB-99 12121 100 04-JUN-99 22222 100 14-MAR-99 23456 100 03-MAR-99 23456 300 14-JUN-99 33333 300 10-MAR-99 25 35 40 50 10 20 10 10 Drive table (note that dri is actually driveno) DRI DRIVENAME DRIVECHAIR LASTYEAR THISYEAR 100 Kids Shelter 200 Animal Home 300 Health Aid Ann Smith Linda Grant David Ross 10000 5000 7000 100 Half Nau Dohont Do

SQL SELECT name, yrgoal, contamt 2 FROM donor, donation 3 WHERE donor.idno = donation.idno AND contamt > yrgoal/12; Donor table IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL CONTACT 11111 Stephen Daniels 123 Elm St 24 Benefit St 24 Benefit St 21 Main St 26 Oak St 36 Pine St Seekonk Providence RI 02045 24-MAY-97 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 MA 02345 03-JUL-98 500 John Smith 12121 Jennifer Ames 400 Susan Jones 22222 Carl Hersey Susan Jones 23456 Susan Ash 33333 Nancy Taylor 100 Amy Costa 50 John Adams 34567 Robert Brooks 50 Amy Costa Donation table (note that dri is actually driveno) IDNO DRI CONTDATE CONTAMT 11111 100 07-JAN-99 11111 200 12-JUN-99 12121 200 23-FEB-99 12121 100 04-JUN-99 22222 100 14-MAR-99 23456 100 03-MAR-99 23456 300 14-JUN-99 33333 300 10-MAR-99 25 35 40 50 10 20 10 10 Drive table (note that dri is actually driveno) DRI DRIVENAME DRIVECHAIR LASTYEAR THISYEAR 100 Kids Shelter 200 Animal Home 300 Health Aid Ann Smith Linda Grant David Ross 10000 5000 7000 100 Half Nau Dohont Do

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Please write a query statement from emp table to display employee's empno, ename, length of ename,…

A: Given that Please write a query statement from emp table to display employee's empno, ename, length…