Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a SQL command to list all the countries by their full names that use Spanish as an official language - Spanish doesn't have to
Write a SQL command to list all the countries by their full names that use Spanish as an official language - Spanish doesn't have to be the only official language. For example:
- Argentina
- Bolivia
- Chile
- Colombia
- ...
(Hint: You will need to join the two tables above.)
Ale 1919 Code Name Continent Region SurfaceArea IndepYear Population LifeExpectancy ABW Aruba North America Caribbean 193.00 MULL 103000 73.4 AFG Afghanistan Southern and Central Asa 652090.00 22720000 45.9 AGO Angola Africa Central Africa 1.24700.00 1975 12878000 AIA Anguilla North America Caribbean 96.00 8000 75.1 ALB Abania Europe Southern Europe 28743.00 1912 3401200 71.6 AND Andorra Europe Southern Europe 468.00 1278 78000 83.5 ANT Netherlands Antilles North America Caribbean 300.00 217000 74.7 ARE United Arab Emirates Asia Middle East 83600.00 1971 2441000 ARG Argentina South America South America 2780400.00 1815 37032000 75.1 ARM Armenia Middle East 29800.00 1991 3520000 66.4 ASM American Samoa Oceania Polynesia 199.00 63000 75.1 ATA Antarctica Antarctica Antarctica 13120000.00 NULL 0 ATF HULLE French Southern ter... Antarctica Antarctica 7780.00 0 74.1 CountryCode ABW ABW ABW ABW AFG AFG AFG AFG AFG Language IsOfficial Dutch T English Papiamento Spanish Balochi F Dari T Pashto T Turkmenian F Uzbek F Ambo F Chokwe F Kongo F Luchazi Luimbe-ng... F Luvale F Mbundu F Nyaneka-n... F Ovimbundu Percentage 5.3 9.5 76.7 7.4 0.9 32.1 52.4 1.9 8.8 2.4 4.2 13.2 2.4 5.4 3.6 21.6 5.4 37.2 AGO AGO AGO AGO AGO AGO AGO AGO AGOStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started