Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
6 rows selected. Problem 5: Determine the output SQL> select from drive: SOL> select * from donor: DRI DRIVENAME DRIVECHAIR LASTYEAR THISYEAR IDNO NAME - ---- CONTACT STADR CITY ST ZIP DATEFST YRGOAL --- --------------- ------------ ---------- ---------- 100 Kids Shelter 200 Animal Home 300 Health Aid Ann Smith Linda Grant David Ross 10000 5000 7000 -- - - - ----- -- -- ------. ------------ 400 Half Way 11111 Stephen Daniels 123 Elm St John Smith Seekonk MA 02345 03-JUL-98 500 Robert Doe 12121 Jennifer Ames Susan Jones SOL> desc donori Name 24 Benefit St Providence RI 02045 24-MAY-97 400 Null? Туре ----- -- -- 24 Benefit St Providence RI 02045 03-JAN-98 22222 Carl Hersey Susan Jonea VARCHAR2 (5) VARCHAR2 (15) VARCHAR2 (15) IDNO NAME STADR VARCHAR2 (10) VARCHAR2 (2) VARCHAR2 (5) DATE NUMBER (7,2) VARCHAR2 (12) CITY IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL STATE -- --- - ZIP ----- ----- ---- - - CONTACT DATEFST YRGOAL CONTACT ---------- 21 Main St 23456 Susan Ash Amy Costa Fall River MA 02720 04-MAR-92 100 33333 Nancy Taylor John Adams SQL> desc donation: Name 26 Oak St Fall River MA 02720 04-MAR-92 150 Null? Туре ----- VARCHAR2 (5) VARCHAR2 (3) ---- IDNO DRIVENO 34567 Robert Brooks 36 Pine St Fall River MA 02720 04-APR-98 50 Amy Costa CONTDATE DATE CONTAMT NUMBER (6,2) 6 rowa selected. SOL> desc drive: SOL> select * from donation: Name Null? Туре IDNO DRI CONTDATE -----. DRIVENO ------ ----- CONTAMT VARCHAR2 (3) VARCHAR2 (15) VARCHAR2 (12) NUMBER (8, 2) NUMBER (8, 2) ----- --- ------- -- -- 11111 100 07-JAN-99 25 DRIVENAME 12121 200 23-FEB-99 23456 100 03-MAR-99 40 20 10 DRIVECHAIR LASTYEAR 33333 300 10-MAR-99 THISYEAR 11111 200 12-FEB-98 12121 200 27-MAY-98 100 120 SQL> select name, VEgsoal, SantamtE 2 from donor, donation 3 where donOEidng - donation.idno and sontamt > XEL9al/12; What output would be produced?

6 rows selected. Problem 5: Determine the output SQL> select from drive: SOL> select * from donor: DRI DRIVENAME DRIVECHAIR LASTYEAR THISYEAR IDNO NAME - ---- CONTACT STADR CITY ST ZIP DATEFST YRGOAL --- --------------- ------------ ---------- ---------- 100 Kids Shelter 200 Animal Home 300 Health Aid Ann Smith Linda Grant David Ross 10000 5000 7000 -- - - - ----- -- -- ------. ------------ 400 Half Way 11111 Stephen Daniels 123 Elm St John Smith Seekonk MA 02345 03-JUL-98 500 Robert Doe 12121 Jennifer Ames Susan Jones SOL> desc donori Name 24 Benefit St Providence RI 02045 24-MAY-97 400 Null? Туре ----- -- -- 24 Benefit St Providence RI 02045 03-JAN-98 22222 Carl Hersey Susan Jonea VARCHAR2 (5) VARCHAR2 (15) VARCHAR2 (15) IDNO NAME STADR VARCHAR2 (10) VARCHAR2 (2) VARCHAR2 (5) DATE NUMBER (7,2) VARCHAR2 (12) CITY IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL STATE -- --- - ZIP ----- ----- ---- - - CONTACT DATEFST YRGOAL CONTACT ---------- 21 Main St 23456 Susan Ash Amy Costa Fall River MA 02720 04-MAR-92 100 33333 Nancy Taylor John Adams SQL> desc donation: Name 26 Oak St Fall River MA 02720 04-MAR-92 150 Null? Туре ----- VARCHAR2 (5) VARCHAR2 (3) ---- IDNO DRIVENO 34567 Robert Brooks 36 Pine St Fall River MA 02720 04-APR-98 50 Amy Costa CONTDATE DATE CONTAMT NUMBER (6,2) 6 rowa selected. SOL> desc drive: SOL> select * from donation: Name Null? Туре IDNO DRI CONTDATE -----. DRIVENO ------ ----- CONTAMT VARCHAR2 (3) VARCHAR2 (15) VARCHAR2 (12) NUMBER (8, 2) NUMBER (8, 2) ----- --- ------- -- -- 11111 100 07-JAN-99 25 DRIVENAME 12121 200 23-FEB-99 23456 100 03-MAR-99 40 20 10 DRIVECHAIR LASTYEAR 33333 300 10-MAR-99 THISYEAR 11111 200 12-FEB-98 12121 200 27-MAY-98 100 120 SQL> select name, VEgsoal, SantamtE 2 from donor, donation 3 where donOEidng - donation.idno and sontamt > XEL9al/12; What output would be produced?

Computer Networking: A Top-Down Approach (7th Edition)
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
icon
Related questions
Question

Need tutoring

6 rows selected. Problem 5: Determine the output SQL> select * from drive; SQL> select * from donor: DRI DRIVENAME DRIVECHAIR LASTYEAR THISYEAR IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL --- ----- ----- 100 Kids Shelter Ann Smith 10000 5000 ----- --- 200 Animal Home 300 Health Aid 400 Half Way CONTACT Linda Grant David Ross 7000 11111 Stephen Daniels 123 Elm St Seekonk MA 02345 03-JUL-98 500 Robert Doe John Smith 12121 Jennifer Ames 24 Benefit St Providence RI 02045 24-MAY-97 400 SQL> desc donor: Susan Jones Name Null? Туре VARCHAR2 (5) VARCHAR2 (15) VARCHAR2 (15) 22222 Carl Hersey 24 Benefit St Providence RI 02045 03-JAN-98 IDNO Susan Jones NAME STADR CITY VARCHAR2 (10) IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL STATE VARCHAR2 (2) ZIP VARCHAR2 (5) ----- CONTACT DATEFST DATE NUMBER (7, 2) VARCHAR2 (12) YRGOAL 23456 Susan Ash 21 Main St Fall River MA 02720 04-MAR-92 100 CONTACT Amy Costa 33333 Nancy Taylor 26 Oak St Fall River MA 02720 04-MAR-92 150 SQL> desc donation; John Adams Name Null? Туре 34567 Robert Brooks 36 Pine St Fall River MA 02720 04-APR-98 50 IDNO VARCHAR2 (5) Amy Costa DRIVENO VARCHAR2 (3) CONTDATE DATE CONTAMT NUMBER (6, 2) 6 rows selected. SQL> desc drive; SQL> select * from donation: Name Null? Туре IDNO DRI CONTDATE CONTAMT DRIVENO VARCHAR2 (3) ----- --- 11111 100 07-JAN-99 25 DRIVENAME VARCHAR2 (15) 12121 200 23-FEB-99 40 DRIVECHAIR VARCHAR2 (12) NUMBER (8, 2) NUMBER (8, 2) 23456 100 03-MAR-99 20 LASTYEAR 33333 300 10-MAR-99 10 THISYEAR 11111 200 12-FEB-98 100 12121 200 27-MAY-98 120 SQL> select name, yrgoal, contamt 2 from donor, donation where donor.idno = donation.idno and contamt > yrgoal/12; ww www omon ww What output would be produced?
Transcribed Image Text:6 rows selected. Problem 5: Determine the output SQL> select * from drive; SQL> select * from donor: DRI DRIVENAME DRIVECHAIR LASTYEAR THISYEAR IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL --- ----- ----- 100 Kids Shelter Ann Smith 10000 5000 ----- --- 200 Animal Home 300 Health Aid 400 Half Way CONTACT Linda Grant David Ross 7000 11111 Stephen Daniels 123 Elm St Seekonk MA 02345 03-JUL-98 500 Robert Doe John Smith 12121 Jennifer Ames 24 Benefit St Providence RI 02045 24-MAY-97 400 SQL> desc donor: Susan Jones Name Null? Туре VARCHAR2 (5) VARCHAR2 (15) VARCHAR2 (15) 22222 Carl Hersey 24 Benefit St Providence RI 02045 03-JAN-98 IDNO Susan Jones NAME STADR CITY VARCHAR2 (10) IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL STATE VARCHAR2 (2) ZIP VARCHAR2 (5) ----- CONTACT DATEFST DATE NUMBER (7, 2) VARCHAR2 (12) YRGOAL 23456 Susan Ash 21 Main St Fall River MA 02720 04-MAR-92 100 CONTACT Amy Costa 33333 Nancy Taylor 26 Oak St Fall River MA 02720 04-MAR-92 150 SQL> desc donation; John Adams Name Null? Туре 34567 Robert Brooks 36 Pine St Fall River MA 02720 04-APR-98 50 IDNO VARCHAR2 (5) Amy Costa DRIVENO VARCHAR2 (3) CONTDATE DATE CONTAMT NUMBER (6, 2) 6 rows selected. SQL> desc drive; SQL> select * from donation: Name Null? Туре IDNO DRI CONTDATE CONTAMT DRIVENO VARCHAR2 (3) ----- --- 11111 100 07-JAN-99 25 DRIVENAME VARCHAR2 (15) 12121 200 23-FEB-99 40 DRIVECHAIR VARCHAR2 (12) NUMBER (8, 2) NUMBER (8, 2) 23456 100 03-MAR-99 20 LASTYEAR 33333 300 10-MAR-99 10 THISYEAR 11111 200 12-FEB-98 100 12121 200 27-MAY-98 120 SQL> select name, yrgoal, contamt 2 from donor, donation where donor.idno = donation.idno and contamt > yrgoal/12; ww www omon ww What output would be produced?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS