Question: Identify the statement that correctly utilizes aliases. a . ) SELECT artist _ id FROM artist AS a JOIN album AS alb USING ( artist

Identify the statement that correctly utilizes aliases.
a.)
SELECT artist_id
FROM artist AS a
JOIN album AS alb
USING (artist_id);
b.)
SELECT album.artist_id
FROM artist AS a
JOIN album AS alb
USING (artist_id);
c.)
SELECT alb.artist_id
FROM artist AS a
JOIN album AS alb
USING (artist_id);
d.)
SELECT artist_id AS a, artist_id AS alb
FROM artist
JOIN album
USING (company_id);

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!