Question: SQL syntax for the following Select statements based on the below: --Select the names of both members and pets that live at 123 2 nd

SQL syntax for the following Select statements based on the below:

--Select the names of both members and pets that live at 123 2nd Ave.

--Select everyone who lives in a house without any pet.

--Select the names and cell phone numbers of everyone who lives with the pet, dog.

MEMBER

Member_ID

Name

Cell

Birthday

Gender

Lives_In

1

Nelson Freeman

614-601-5147

1-Jun-1922

M

1

2

Mercy Mader

614-624-6628

12-Jan-1918

F

1

3

William Mack

614-949-2522

12-Aug-1923

M

2

4

Mary Burbank

614-512-9725

15-Feb-1922

F

2

5

Enoch Whitman

216-848-9837

16-Dec-1918

M

3

6

Rebecca Gardner

25-May-1923

F

3

7

Samuel Hunt

513-395-7045

26-Aug-1922

M

4

8

Lucerna Harlow

513-786-2650

3-Sep-1918

F

4

9

David Freeman

513-545-8812

28-Nov-1948

M

5

10

Desiah Mack

513-802-5776

14-Oct-1947

F

5

11

Nathanial Whitman

216-596-6123

17-Jun-1943

M

3

12

Jane Hunt

216-596-6321

29-Jan-1948

F

3

13

Joseph Freeman

312-893-2254

27-Dec-1972

M

6

14

Abigale Whitman

773-254-8919

3-Feb-1968

F

6

15

Samuel Freeman

15-Mar-1998

M

6

16

Jessica Freeman

614-719-9213

22-Jul-1952

F

1

17

Alex Whitman

216-596-6240

23-Jan-1948

M

3

PARENT

Mother_ID

Father_ID

Child_ID

1

2

9

1

2

16

3

4

10

5

6

11

5

6

17

7

8

12

9

10

13

11

12

14

13

14

15

PET

Pet_ID

PName

Type

Year_born

House_In

1

Murfee

Dog

2008

1

2

Rufus

Dog

2015

1

3

Whiskers

Cat

2010

2

4

Jingles

Potbelly Pig

2014

3

5

Tweet

Canary

2013

5

HOUSEHOLD

House_ID

Street_Address

City

State

Zip

1

321 High St.

Columbus

OH

43050

2

123 2nd Ave.

Columbus

OH

43052

3

444 Main Dr.

Cleveland

OH

44101

4

999 Freeland St.

Cincinnati

OH

45220

5

265 Iota Ave.

Cincinnati

OH

45220

6

102 Michigan Ave.

Chicago

IL

60632

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

SQL syntax for the following Select statements based on the below: --Select the names of both members and pets that live at 123 2 nd Ave. (USE A UNION STATEMENT) --Select everyone who lives in a...

Q:

The problem As a Database Administrator (DBA), you have been provided with the following account detailing the access security criteria for a SQL database system. The database consists of three...

Q:

C HAP TER 1 Culturally Intelligent Leadership Matters The rst time I taught cultural intelligence principles to a group of executives in Minnesota, I miscalculated the time and distance it would take...

Q:

Write the SQL code for the following: List the class name, room, location, day, and time for all classes. Write the SQL code for the following: Display the last names of the customers who have...

Q:

Can i get help with my practice exam? I wanna compare it to mine but i have nobody to do it with. Practice quiz for final Question 1 (2 points) What are the two main goals of estate planning?...

Q:

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

Q:

I hope you can answer this question and find the reference below the question. Thank you Topic: Conducting personal job interviews using the STAR model 1- Design a two-hour training work plan for 10...

Q:

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Q:

A dealership is trying to understand its customers better. A survey was conducted among 100 customers to determine their favorite color for a sedan. Which statement is true? a.) All people who...

Q:

Hello, I need help with with Return of the Tallahassee Beancounters Case (the 2010 version). The solution and teachers handouts for the 2003 version have already been made available, however it's...

Q:

Give the chains of range spaces and null spaces for the zero and identity transformations.

Q:

Question 3 On January 1, 2017, Hoist Up Company (HUC) purchased bonds of Southern Inc. that had the following characteristics: 12% coupon rate, $300,000 face value, maturing on December 31, 2021, and...

Q:

10. If the Str_length procedure from Section 9.3 used SCASB, how would it calculate and return the string length?

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

From a Comparable Worth Standpoint, what is the situation with regard to Federal Gender-based Employee Pay Equity?

Q:

Provide an example of how drilling down further into information can yield new results.

Q:

What do Dimensions represent in OLAP Cubes?