Please help me! clarify the answer ### SQL Table Join Example: An Educational Guide#### Query ExplanationBelow is an illustrative example of an SQL query that joins two tables — `donor` and `donation` — and retrieves specific data:```sqlSELECT name, yrgoal, contamtFROM donor, donationWHERE donor.idno = donation.idno AND contamt > yrgoal/12;```This query selects the `name`, `yrgoal`, and `contamt` fields from the `donor` and `donation` tables where the `idno` from both tables match and the `contamt` (contribution amount) is greater than the `yrgoal` divided by 12.#### Donor Table- **Columns:** - `IDNO`: Donor identification number. - `NAME`: Donor's name. - `STADR`: Street address. - `CITY`: City of residence. - `ST`: State abbreviation. - `ZIP`: Zip code. - `DATEFST`: Date of first donation. - `YRGOAL`: Yearly contribution goal. - `CONTACT`: Contact person.Data example:```IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL CONTACT----- ------------------- --------------- ------------ -- ----- -------- ------- ----------------11111 Stephen Daniels 123 Elm St Seekonk MA 02345 03-JUL-98 500 John Smith12211 Jennifer Ames 24 Benefit St Providence RI 02045 24-MAY-97 400 Susan Jones22222 Carl Hersey 24 Benefit St Providence RI 02045 03-JAN-98 Susan Jones23456 Susan Ash 21 Main St Fall River MA 02720 04-MAR-92 100 Amy Costa33333 Nancy Taylor 26 Oak St Fall River MA 02720 04-MAR-92 50 John Adams34567 Robert Brooks 36 Pine St Fall River MA 02720 04-APR-98 50 Amy Costa```#### Donation Table- **Columns:** - `IDNO`: Identifies which donor made the donation. - `DRI`: Drive number

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: "Multi-factor authentication" means validating an individual's identity using two or more methods.…

A: Multi-factor authentication (MFA) is a security method that verifies a person's identity using two…

Q: Read Blown to Bits pages 253-257 write a response to the following two prompts. Your prompts should…

A: Internet: The internet is a vast network of computers and other devices that are connected,…

Q: To translate an unsigned decimal integer into binary, repeatedly divide the integer by 2, saving…

A: The question prompts an exploration of a fundamental concept in computer science – the conversion of…

Q: On the internet, how can you discern the difference between phoney and true information?

A: The discern the difference between phoney and true information are given below:

Q: f any newly discovered dangers associated with the Internet of Things?

A: According to the question, a Basic foundation that includes government institutions, utilities,…

Q: Question 4. Convert 1101.10018 to hexadecimal and decimal numbers.

A: Given (1101.1001)8 Octal to Hexadecimal: First, convert the given octal number to binary. 001 in…

Q: Message authentication has several methods.

A: Yes of course there are always the list of method available for the authentication we have to choose…

Q: Please elaborate on the reasons why, in this technologically advanced day, authentication remains…

A: Providing dependable, trustworthy, and robust authentication is an essential method of ensuring…

Q: Why do we touch each other, and what does it mean?

A: Not everyone likes to touch or to be touched. But, you are correct that most of us enjoy the warmth…

Q: On the internet, how can you discern the difference between phoney and true information?

A: Answer : On internet if you have to differentiate between false and true information than most…

Q: One to one correspondence (45AF16)(2C16) = base 7. %3D

A: (45AF)16 = N7 Let's convert it to decimal first, then in "to base 7". Thus 45AF = 4*163 + 5*162 +…

Question

Please help me! clarify the answer

### SQL Table Join Example: An Educational Guide

#### Query Explanation

Below is an illustrative example of an SQL query that joins two tables — `donor` and `donation` — and retrieves specific data:

```sql
SELECT name, yrgoal, contamt
FROM donor, donation
WHERE donor.idno = donation.idno AND contamt > yrgoal/12;
```

This query selects the `name`, `yrgoal`, and `contamt` fields from the `donor` and `donation` tables where the `idno` from both tables match and the `contamt` (contribution amount) is greater than the `yrgoal` divided by 12.

#### Donor Table

- **Columns:**
- `IDNO`: Donor identification number.
- `NAME`: Donor's name.
- `STADR`: Street address.
- `CITY`: City of residence.
- `ST`: State abbreviation.
- `ZIP`: Zip code.
- `DATEFST`: Date of first donation.
- `YRGOAL`: Yearly contribution goal.
- `CONTACT`: Contact person.

Data example:
```
IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL CONTACT
----- ------------------- --------------- ------------ -- ----- -------- ------- ----------------
11111 Stephen Daniels 123 Elm St Seekonk MA 02345 03-JUL-98 500 John Smith
12211 Jennifer Ames 24 Benefit St Providence RI 02045 24-MAY-97 400 Susan Jones
22222 Carl Hersey 24 Benefit St Providence RI 02045 03-JAN-98 Susan Jones
23456 Susan Ash 21 Main St Fall River MA 02720 04-MAR-92 100 Amy Costa
33333 Nancy Taylor 26 Oak St Fall River MA 02720 04-MAR-92 50 John Adams
34567 Robert Brooks 36 Pine St Fall River MA 02720 04-APR-98 50 Amy Costa
```

#### Donation Table

- **Columns:**
- `IDNO`: Identifies which donor made the donation.
- `DRI`: Drive number

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

In a few words, describe the part.
create a search statement on: The effect of the COVID-19 pandemic on higher education. Using Boolean operators
Please elaborate on the reasons why, in this technologically advanced day, authentication remains problematic.
What are some of the reasons why it is more probable that the intention of an email may be misunderstood? There are at least two helpful ways that you may conduct yourself in a professional manner in the email conversation that you have. What about the following understanding of the phrase?