Question: Write the SQL Query for the following. Code provided. Include the semicolons and screenshots of the outputs. -- Given the bsg_planets table created by using

Write the SQL Query for the following. Code provided. Include the semicolons and screenshots of the outputs.

Write the SQL Query for the following. Code provided. Include the semicolons

-- Given the bsg_planets table created by using the following definition query :

--

-- CREATE TABLE `bsg_planets` (

-- `id` int(11) NOT NULL AUTO_INCREMENT,

-- `name` varchar(255) NOT NULL,

-- `population` bigint(20) DEFAULT NULL,

-- `language` varchar(255) DEFAULT NULL,

-- `capital` varchar(255) DEFAULT NULL,

-- PRIMARY KEY (`id`),

-- UNIQUE KEY `name` (`name`)

-- ) ENGINE=InnoDB DEFAULT CHARSET=latin1

--

-- Insert information about the planet Mars which has a population of 2,

-- language as "Binary" and "Olympus Mons" as Capital, in bsg_planets. Then

-- list the row(s), with all the information for that planet. - 12 points

-- Write your query BELOW this line.

5. Insert information about the planet Mars which has a population of 2, language as "Binary" and "Olympus Mons" as Capital, in bsg_planets. Then list the row(s), with all the information for that planet. -- 12 points

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!