View the Exhibit. To display only the names of all cities In Italy, you could perform which two
tasks?
A.
Run the following SQL query in the SQL Commands worksheet area. SELECT locations.
City FROM locations, countries WHERE countries.country_id=locations.country_id AND
Countries. country__name=f Italy’;
B.
Use Query Builder to select the countries and locations tables. Create a join between the
two tables by using the country_id column. Then, select the city column in the locations
table and country_name column in the countries table. For the country_name, specify the
condition =‘Italy’. Uncheck the Show check box for country_name.
C.
Run the following SQL query in the SQL Commands worksheet area. SELECT locations,
city FROM locations, countries WHERE countries.country_name=’Italy’;
D.
Use Query Builder to select the countries and locations tables. Create a join between the
two tables by using the country_id column. Then, select the city column in the locations
table and country_name column in the countries table. For the country_name, specify the
condition = ‘ Italy’.
E.
Use Query Builder to select the countries and locations tables. Select the country_id
column in both the tables and create a join between them. Then, select the city column in
the locations table and country_name column in the countries table. For the country name,
specify the condition ‘Italy’.