insert into donation(volunteer_id, charity_id, donation_amount) values(\"America

Question

insert into donation(volunteer_id, charity_id, donation_amount) values("American Red Cross",1,1000);
insert into donation(volunteer_id, charity_id, donation_amount) values("American Cancer Society",2, 500);
insert into donation(volunteer_id, charity_id, donation_amount) values("Puppies Behind Bards",3, 750);
insert into donation(volunteer_id, charity_id, donation_amount) values("American Red Cross",1, 500);
insert into donation(volunteer_id, charity_id, donation_amount) values("St. Judes Childrens Hospital",4, 500);

volunteer hours volunteer xnumber VARCHAR(6) volunteerdste DATE arganizatan VARCHAR(45) num hours INT(11) Indéxés dona tion spring_break_2018 majo d INT(11) ttle VARCHAR (45 department VARCHAR(4 dffers hanars TINYINT 1 tertyid INT(11) bretor-amount INT(11) | app-name VARCHAR(40) apploc VARCHAR 20) volunteer xmbe VARCHAR(6) asname VARCHAR30) frst- ame VARCHAR(30) Indexes Indéxès charity id INT(11) charity name VARCHARBO) company daabirth DATE d VARCHAR(2) grad year YEAR(4) Obarracks VARCHAR)majprd INT(11) foreign-language In déxès tac VARCHAR 45) compry_d VARCHAR(2) pid INT11) id DIT(11) leng-name VARCHAR(15) Indéxès Indéxès In déxès volunteer_knows_toreign languaqu volunteexnumber VARCHAR (6) bregnlanguageid INT 11 proficiency VARCKR(45) Indéxès

Explanation / Answer

select v.first_name, d.donation_amount

from volunteer v, donation d

where v.volunteer_id=d.volunteer_id.

selecting first name i.e we want volunteer name and donation amount.

Both are in 2 tables i.e volunteer and donation tables.

common point between 2 tables in volunteer id. so the condition is they should be equal.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.