2022-11-17：组合两个表。请写出 sql 语句，执行结果是{“headers“: [“first_name“, “last_name“, “city“, “state“], “values“: [

DROP TABLE IF EXISTS `address`;CREATE TABLE `address` (  `address_id` int(11) NOT NULL,  `person_id` int(11) NOT NULL,  `city` varchar(255) NOT NULL,  `state` varchar(255) NOT NULL,  PRIMARY KEY (`address_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;INSERT INTO `address` VALUES ('1', '2', 'New York City', 'New York');INSERT INTO `address` VALUES ('2', '3', 'Leetcode', 'California');
DROP TABLE IF EXISTS `person`;CREATE TABLE `person` (  `person_id` int(11) NOT NULL,  `first_name` varchar(255) NOT NULL,  `last_name` varchar(255) NOT NULL,  PRIMARY KEY (`person_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;INSERT INTO `person` VALUES ('1', 'Allen', 'Wang');INSERT INTO `person` VALUES ('2', 'Bob', 'Alice');

select first_name, last_name, city, statefrom person left join addresson person.person_id = address.person_id