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.
Explanation:
A (not D): The WHERE constraints ” countries.country_id=locations.country_id”
ensures that a correct join is made on the two tables.
Only the City column in displayed through the SELECT statement
E: Join between the tables.
Put a condition on the Country_name.
Only display the City column