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’.
C.
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’.
D.
Run the following SQL query in the SQL Commands worksheet area.
SELECT locations, city
FROM locations, countries
WHERE countries.country_name=’Italy’;
E.
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.