Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

-- 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application Development And Administration

Authors: Michael V. Mannino

4th Edition

0615231047, 978-0615231044

More Books

Students also viewed these Databases questions