Question $16$

Not yet answered Marked out of $2,00$

Which of the following is a valid query to find the locations whose country$\_$id is the same as country$\_$name $=$ 'United States of America':

a$.$ SELECT City, country$\_$id FROM locations WHERE country$\_$id in $($select country$\_$id from countries where country$\_$name like 'United States of America'$)$;

b$.$ SELECT City, country$\_$id FROMM locations WHERE country$\_$name $=($select country$\_$id from countries where country$\_$name like 'United States of America'$)$;

c$.$ SELECT City, country$\_$id FROM locations WHERE country$\_$id in $($select country$\_$id from locations where country$\_$name like 'United States of America'$)$;

d$.$ SELECT City, country$\_$id FROM countries WHERE country$\_$id in $($select country$\_$id from countries where country$\_$name like 'United States of America'$)$;

e$.$ None of the mentioned