Question: Using the MYSQL WORLD database - this can be found online if you don't have it. Write SQL code to answer the following questions: 1.In

Using the MYSQL WORLD database - this can be found online if you don't have it.

Write SQL code to answer the following questions:

1.In which countries the languages spoken by the majority (i.e., more than 50%) of the #population are not official?

2..In which countries 10 or more languages are spoken?

3. Which countries have three or more official languages?

4. In which countries a language that is spoken the least is an official language? (The language #must have more than 0 percent speakers).

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!

Q:

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

Q:

database management system COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI AHMI DR. MOHD...

Q:

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

Q:

Decide if the speech adjustments below are about dialect or register differences. I say when I'm in Mexico, but when I'm in Argentina. I say when my friends tell me an incredible story, but if a...

Q:

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Q:

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Q:

Assignment 3 oh Assignments 3 and 4 will give you practice applying what you learned in module 2 to actually create and query a small database using SQL. You will use a very popular open source...

Q:

According to the information below please answer the following questions: ENTR 187 Business Plan App Translator Industry Analysis INDUSTRY SIZE When you talk into your phone in any of the Worlds...

Q:

Please read the questions Question: In your own words, describe the two orientations that schools can develop, Intercultural Orientation and Assimilationist Orientation. Provide an example...

Q:

Please read the questions Question: Please explain in your own words, what transformative pedagogy is. Also, describe the ways in which you can include students' cultures and languages in a lesson...

Q:

Congestion control refers to techniques and mechanisms that can either prevent congestion, before it happens, or remove congestion, after it has happened. In general, we can divide congestion control...

Q:

A monthly depositor: A. will remain a monthly depositor, once classified, for one year at which time they will be reevaluated. B. is determined by the amount of Form 941 taxes that they paid in the...

Q:

? _ _ _ _ _ _ _ r e f e r s t o t h e c o n c e p t t h a t a m a n a g e r w i l l o n l y i n v e s t i g a t e b u d g e t v a r i a n c e s t h a t a r e r e l a t i v e l y l a r g e . A n s w e...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

2. What rewards might be offered to front-line workers for working safely and preventing injuries? What rewards might be offered to job site managers who safely lead projects?

Q:

3. Employee accountability. Based on 20 identified unsafe behaviors, all employees (managers as well as craftspeople) were expected to report any violations they witnessed on a project site.

Q:

3. Visit the Messer Construction company website at http://messer.com/process/safety4site. How has the Safety4Site program impacted Messers business outcomes? Has the company been awarded any...