Suppose you have an ADDRESS_BOOK table containing the first and last names, addresses, and birthdays of many people you know. How can you write a query to display the names of pairs of your acquaintances who have the same birthday?
A) create a new set using ADDRESS_BOOK
B) perform an outer join on ADDRESS_BOOK
C) self-join ADDRESS_BOOK to itself
D) create a second BIRTHDAY table

Question

Quizplus · Accepted Answer

A self-join on the ADDRESS_BOOK table allows you to compare rows within the same table to find pairs of acquaintances who share the same birthday.

Suppose You Have an ADDRESS_BOOK Table Containing the First and Last