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
Get step-by-step solutions from verified subject matter experts
