Question: Consider the table, created using the following definition queries for the question, and answer the question using sql query. CREATE TABLE `bsg_people` ( `id` int(11)
Consider the table, created using the following definition queries for the question, and answer the question using sql 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
Find the first name, last name, and age of people from bsg_people whose age is NULL
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
