Given the following two tables:
NAMES
NAME NUMBER
———- ——-
Wayne Gretzky 99
Jaromir Jagr 68
Bobby Orr 4
Bobby Hull 23

Brett Hull 16
Mario Lemieux 66
Mark Messier 11
POINTS
NAME POINTS
———- ——
Wayne Gretzky 244
Jaromir Jagr 168
Bobby Orr 129
Brett Hull 121
Mario Lemieux 189
Joe Sakic 94
Which of the following statements will display the player name, number, and points for all players
that have scored points?

A.
SELECT p.name,n.number, p.points FROM names n INNER JOIN points p ON n.name =
p.name

B.
SELECT p.name,n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name
= p.name

C.
SELECT p.name,n.number, p.points FROM names n RIGHT OUTER JOIN points p ON n.name
= p.name

D.
SELECT p.name,n.number, p.points FROM names n FULL OUTER JOIN points p ON n.name
= p.name