Computers and Technology, 17.04.2020 04:29 lasdivisionst6459

Using the world_x database you installed in Module 1, list the countries and the capitals of each country. Modify your query to limit the list to those countries where less than 30% of the population speaks English. Be sure to identify the literary sources you used to look up any SQL syntax you used to formulate your query. Submit your query and query results Word file.

Answers: 3

Show answers

Answers

Answer from: JadeK4853

SELECT country.Name, city.Name

FROM country

JOIN countrylanguage ON country.Code = countrylanguage.CountryCode

JOIN city ON country.Capital = city.ID

WHERE countrylanguage.Language = 'English'

AND countrylanguage.Percentage < 30;

Explanation:

SELECT is used to query the database and get back the specified fields.

City.Name is an attribute of city table.

country.Name is an attribute of country table.

FROM is used to query the database and get back the preferred information by specifying the table name.

country , countrylanguage and city are the table names.

country and countrylanguage are joined based ON country.Code = countrylanguage.CountryCode

countrylanguage and city are joined based ON country.Capital = city.ID

WHERE is used to specify a condition based on which the data is to be retrieved. The conditions are as follows:

countrylanguage.Language = 'English'

countrylanguage.Percentage < 30;

Answer from: Quest

how does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the statehow does the creation of jobs in georgia impact the largest source of revenue for the state

Answer from: Quest

i'm so sorry that's not a question and this isn't an answer

Another question on Computers and Technology

Computers and Technology, 22.06.2019 03:40

Hello my name is mihai and i need your : )i have to do a python project in computer science and i’m really busy with my mocks this period of time besides this i’m not good at coding so could someone pls pls pls sort me out ? i actually beg ; ))

Answers: 1

Answer

Computers and Technology, 24.06.2019 02:20

Peter is thinking of a number which isless than 50. the number has 9 factors.when he adds 4 to the number, itbecomes a multiple of 5. what is thenumber he is thinking of ?

Answers: 1

Answer

Computers and Technology, 24.06.2019 03:30

Explain the importance of html in web page designing in 20 sentences..

Answers: 1

Answer

Computers and Technology, 24.06.2019 18:20

7. design a circuit with three inputs (x, y, and z) representing the bits in a binary number, and three outputs (a, b, and c) also representing bits in a binary number. when the input is 1, 2, or 3, the binary output should be one lesser than the input. when the input is 4, 5, or 6, the binary output should be one greater than the input. when the input is 0, the output is 0, and when the input is 7, the output is 7. show your truth table, all computations for simplification, and the final circuit.

Answers: 2

Answer

You know the right answer?

Using the world_x database you installed in Module 1, list the countries and the capitals of each co...

Questions