Question

ch8p2. Display a listing of animals and their volunteer's name. If the animal does not have a volunteer, display 'No volunteer assigned'. Display the columns as shown below: ch8p3. Animals Volunteer Report No volunteer assigned to Ginger No volunteer assigned to Pepi No volunteer assigned to Rascal No volunteer assigned to Sasha No volunteer assigned to Shadow No volunteer assigned to Tweety Volunteer Abraham Clark assigned to Rocky Volunteer Carol Knotts assigned to Peanut Volunteer Carol Knotts assigned to Romeo Volunteer Carol Knotts assigned to Samantha Volunteer Catherine Johnson assigned to Max Volunteer Catherine Johnson assigned to Mystic Volunteer Geralyn Bouquet assigned to Sophie Volunteer Gwen Claiborne assigned to Daisy Volunteer Janice LeBlanc assigned to Frisco Volunteer Janice LeBlanc assigned to Lovey Volunteer Jim Maurice assigned to Precious Volunteer Jim Maurice assigned to Tigger Volunteer Joseph Silvia assigned to Coco Volunteer Mimi Jannik assigned to Dakota Volunteer Patrice Ferrier assigned to Snowball Volunteer Ron Kingsley assigned to Duke Volunteer Ron Kingsley assigned to Midnight Using the Animal Shelter Schema, create a query that will display the name of the birds along with the name of any potential adopters. Order by column 1. May be adopted by: Potential Adopter Tweety Joseph Rikard

          ch8p2.
Display a listing of animals and their volunteer's name. If the animal does not have a volunteer, display
'No volunteer assigned'. Display the columns as shown below:
ch8p3.
Animals Volunteer Report
No volunteer assigned to Ginger
No volunteer assigned to Pepi
No volunteer assigned to Rascal
No volunteer assigned to Sasha
No volunteer assigned to Shadow
No volunteer assigned to Tweety
Volunteer Abraham Clark assigned to Rocky
Volunteer Carol Knotts assigned to Peanut
Volunteer Carol Knotts assigned to Romeo
Volunteer Carol Knotts assigned to Samantha
Volunteer Catherine Johnson assigned to Max
Volunteer Catherine Johnson assigned to Mystic
Volunteer Geralyn Bouquet assigned to Sophie
Volunteer Gwen Claiborne assigned to Daisy
Volunteer Janice LeBlanc assigned to Frisco
Volunteer Janice LeBlanc assigned to Lovey
Volunteer Jim Maurice assigned to Precious
Volunteer Jim Maurice assigned to Tigger
Volunteer Joseph Silvia assigned to Coco
Volunteer Mimi Jannik assigned to Dakota
Volunteer Patrice Ferrier assigned to Snowball
Volunteer Ron Kingsley assigned to Duke
Volunteer Ron Kingsley assigned to Midnight
Using the Animal Shelter Schema, create a query that will display the name of the birds along with the
name of any potential adopters. Order by column 1.
May be adopted by: Potential Adopter
Tweety	Joseph Rikard

ch8p2.
Display a listing of animals and their volunteer's name. If the animal does not have a volunteer, display
'No volunteer assigned'. Display the columns as shown below:
ch8p3.
Animals Volunteer Report
No volunteer assigned to Ginger
No volunteer assigned to Pepi
No volunteer assigned to Rascal
No volunteer assigned to Sasha
No volunteer assigned to Shadow
No volunteer assigned to Tweety
Volunteer Abraham Clark assigned to Rocky
Volunteer Carol Knotts assigned to Peanut
Volunteer Carol Knotts assigned to Romeo
Volunteer Carol Knotts assigned to Samantha
Volunteer Catherine Johnson assigned to Max
Volunteer Catherine Johnson assigned to Mystic
Volunteer Geralyn Bouquet assigned to Sophie
Volunteer Gwen Claiborne assigned to Daisy
Volunteer Janice LeBlanc assigned to Frisco
Volunteer Janice LeBlanc assigned to Lovey
Volunteer Jim Maurice assigned to Precious
Volunteer Jim Maurice assigned to Tigger
Volunteer Joseph Silvia assigned to Coco
Volunteer Mimi Jannik assigned to Dakota
Volunteer Patrice Ferrier assigned to Snowball
Volunteer Ron Kingsley assigned to Duke
Volunteer Ron Kingsley assigned to Midnight
Using the Animal Shelter Schema, create a query that will display the name of the birds along with the
name of any potential adopters. Order by column 1.
May be adopted by: Potential Adopter
Tweety Joseph Rikard

Added by Bruce M.

Question

Please give Ace some feedback