Question: -- Given the bsg_people table created by using the following definition query : -- -- CREATE TABLE `bsg_people` ( -- `id` int(11) NOT NULL AUTO_INCREMENT,

-- Given the bsg_people table created by using the following definition query : -- -- CREATE TABLE `bsg_people` ( -- `id` int(11) NOT NULL AUTO_INCREMENT, -- `fname` varchar(255) NOT NULL, -- `lname` varchar(255) DEFAULT NULL, -- `homeworld` int(11) DEFAULT NULL, -- `age` int(11) DEFAULT NULL, -- PRIMARY KEY (`id`), -- KEY `homeworld` (`homeworld`), -- CONSTRAINT `bsg_people_ibfk_1` FOREIGN KEY (`homeworld`) REFERENCES `bsg_planets` (`id`) ON DELETE SET NULL ON UPDATE CASCADE -- ) ENGINE=InnoDB -- Delete all people whose age is NULL. Then, list all such people whose age is NOT NULL.

--MAKE THE SQL 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!

Write a SQL Query to find the population of this table named 'Caprica'. Code provided. Include the semicolons and screenshots of the outputs. -- Given the bsg_people table created by using the...

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 the following definition query : -- --...

Assignment 6 Florida International University Student Name: Dario Francis Department of Knight Foundation Student ID: 6 3 6 4 3 3 7 School of Computing and Information Sciences CTS 4 4 0 8 : Database...

Question: Using SQL Consider the two tables, created using the following definition queries for all the questions: bsg_people CREATE TABLE `bsg_people` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fname`...

using SQL consider the two tables, created using the following definition queries ... Consider the two tables, created using the following definition queries for all the questions: bsg_people CREATE...

Assume that we have two tables bsg_people and bsg_planets. Just write the correct sql queries pertaining to the questions. CREATE TABLE `bsg_people` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fname`...

Hello, I am completing a mysql question using these parameters: feature: This is a 'normalized' schema, and all biological feature types are stored in this same table. The type_id column...

Using SQL and the following info Question 3: Find the people who do not have Viper Certification but are still assigned to Viper class ship Find the fname, lname, and ship_instance_id for all people...

What are the components of the attitude-toward-the-object model? What are the components of the theory of reasoned action?

Calculate January's ending inventory and cost of goods sold for the month using LIFO, perpetual system. Cost of Goods Available for Sale Cost of Goods Sold - January 5 Cost of Goods Sold - January 12...

The purpose of having a Domain Name services ( DNS ) system in place is to convert Domain names to IP addresses when browsing the internet. Select one: True False

Exercise 25-23 Sell or process further LO A1 Cobe Company has already manufactured 18,000 units of Product A at a cost of $15 per unit. The 18,000 units can be sold at this stage for $480,000....

1. Opportunities for face-to-face contact will be diminished, and information from nonverbal cues will be reduced. Consequently, opportunities for random spontaneous information sharing will be...

How does the team fit into the overall management structure of the organization, classroom, and so on?

5. The computer imposes a discipline of linear thinking. Organizations will need to find ways to encourage and protect nonlinear thinking and communicating.