Session Ready
Exercise

A table of two cities

This exercise looks to explore languages potentially and most frequently spoken in the cities of Hyderabad, India and Hyderabad, Pakistan.

You will begin with a cross join with cities AS c on the left and languages AS l on the right. Then you will modify the query using an inner join in the next tab.

Instructions 1/2
undefined XP
  • 1
  • 2
  • Create the cross join as described above. (Recall that cross joins do not use ON or USING.)
  • Make use of LIKE and Hyder% to choose Hyderabad in both countries.
  • Select only the city name AS city and language name AS language.