Question: Write the SQL Query for the following. Code provided. Include the semicolons and screenshots of the outputs. -- Create a table with the following columns,
Write the SQL Query for the following. Code provided. Include the semicolons and screenshots of the outputs.

-- Create a table with the following columns, named bsg_spaceship
--
-- id - an auto-incrementing integer which is also the primary key
-- name - variable-length string with a max of 255 characters, cannot be null
-- separate_saucer_section - a boolean property which specifies whether or not there is a separate saucer section on the spaceship. This defaults to No.
-- length - integer, cannot be null
--
-- Once you have created the table, run the query "DESCRIBE bsg_spaceship;"
-- Write your queries BELOW this line
8. Create a table with the following columns, named bsg_spaceship. -- 20 points .id - an auto-incrementing integer which is also the primary key name - variable-length string with a max of 255 characters, cannot be null separate_saucer_section - a boolean property which specifies whether or not there is a separate saucer section on the spaceship. This defaults to No. Cannot be null length - integer, cannot be null Once you have created the table, run the query "DESCRIBE bsg_spaceship
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
