Question: Please show a screenshot on how to execute the query for PART 3 that is my main focus and I am having a lot of

Please show a screenshot on how to execute the query for PART 3 that is my main focus and I am having a lot of problems with it

Download the world-x database from the following MySQL website: http://dev.mysql.com/doc/index-other.html (Links to an external site.)Links to an external site.

Create a database user named jump with password start.

Load the world-xdatabase into your MySQL database instance.

Grant create, drop, alter, insert, update, select, delete, and index privileges for user jump on the world-x database.

PART 2

Using the world_x database you installed in Module 1 and your MySQL Workbench, create a new table named independence with the following attributes (columns):

A field named id which has data type auto_increment,

A field named country_name which has data type varchar(50), and

A field named independence_date which has type date.

After you create the table, run the following SQL command:

INSERT INTO independence(country_name, independence_date) VALUE (United States,1776-07-04)
PART 3 
 

Using the world_x database you installed in Module1, list the codes for countries where English is spoken by more than 30% of the population. Submit your query and query results in a Word file.

In your document, suggest another query where you list the country codes for countries where English is spoken by less than 30% of the population. Be sure to identify the literary sources you used to look up any SQL syntax you used to formulate your query.

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!