Question: Select the query that properly uses table aliases to show the genres of each track in the Album with the id of 6 . SELECT
Select the query that properly uses table aliases to show the genres of each track in the Album with the id of
SELECT gname, tname
FROM t AS track
JOIN g AS genre
USING genreid
WHERE talbumid;
SELECT genre.name, track.name
FROM track
JOIN genre
USING genreid
WHERE track.albumid;
SELECT gname tname
FROM track AS t
JOIN genre AS g
USING genreid
WHERE talbumid;
SELECT gname, tname
FROM track AS t
JOIN genre AS g
USING genreid
WHERE talbumid;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
