Question: country ( code , name, continent, population) countrylanguage ( countrycode , countrylanguage, isofficial, percentage) Find all countries in Africa that have a language spoken by

country(code, name, continent, population) countrylanguage(countrycode, countrylanguage, isofficial, percentage)

Find all countries in Africa that have a language spoken by fewer than 1% of the population. Report the country names only (as attribute 'name'); do not include any duplicates. (Note that the percentage attribute stores a number between 0 and 100.) Hint: Go through all the countries in Africa and use EXISTS to check the other condition.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Consider the World database that contains the City, Country and CountryLanguage tables: City ( id - > name, countrycode, district, population, . . . ) Country ( code - > name, continent, region,...

A. Continent_summary_view: Create a view to display each continent name, the number of countries in the continent, the total surface areas, and the total populations. B. Population_view : Create a...

MY SQL PLEASE For this lab, complete the following tasks and upload screen shots of your code and the results. 1. Create a stored procedure that takes a city name for input (IN) and returns the...

- - 8 . Notice that in this database cities are grouped in "districts" not states. This is because many countries don't have states, they have provinces or some other subdivisions. Write a report...

Write a report that shows all the cities in the world that start with " S " , where Spanish is the official language and only list cities that are the capital of its country. Include the name of the...

country ( code , name, continent, population ) countrylanguage ( countrycode , countrylanguage, isofficial, percentage ) Report the code of every country where 'French' is an official language.

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...

Table: city column name data type size notes about the data ID Number 11 City Id Code (primary key) name Text 35 Name of City country Code Text 3 Country Code foreign Key to Country(Code) District...

Introduction to SQL help. Import the following database file city.sql city.sql file down below: CREATE DATABASE COUNTRIES; USE COUNTRIES; DROP TABLE IF EXISTS `City`; CREATE TABLE `City` ( `ID`...

Please write the query statements for the questions below, Thank You! Table: city column name data type size notes about the data ID Number 11 City Id Code (primary key) name Text 35 Name of City...

The U.S Energy Information Administration collects data on residential energy consumption and expenditures. Results are published in the document Residential Energy Consumption Survey: Consumption...

Victor French made deposits of $5,000 at the end of each quarter to Book Bank, which pays 8% interest compounded quarterly. After 3 years, Victor made no more deposits. What will be the balance in...

Outline the main types (and hence the causes) of unemployment.

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

Choose the most effective approach to performance measurement for a given situation. page 350

Conduct an effective performance feedback session. page 360

List the major elements that contribute to perceptions of justice and how to apply these in organizational contexts involving discipline and dismissal. page 425