Question

Identify the statement that correctly utilizes aliases.

A) SELECT id, , FROM track AS t JOIN genre AS g USING (genre id);
B) SELECT id, , FROM track AS t JOIN genre AS g USING (genre id);
C) SELECT id, name AS track name, name AS genre name FROM track AS t JOIN genre AS g USING (genre id);
D) SELECT id, name FROM track AS t JOIN genre AS g USING (genre id);

Answer 1

The correct statement that utilizes aliases is option C: SELECT id, name AS track name, name AS genre name FROM track AS t JOIN genre AS g USING (genre id).

Step-by-step explanation:

Identify the statement that correctly utilizes aliases.

The correct statement that utilizes aliases is option C:

• 
  
• SELECT id, name AS track name, name AS genre name FROM track AS t JOIN genre AS g USING (genre id);

In this statement, aliases are used to differentiate the names of the track and genre columns in the result set. By using the 'AS' keyword, the column 'name' from the 'track' table is renamed as 'track name', and the column 'name' from the 'genre' table is renamed as 'genre name'.