Given the table customers which contains columns customer_id, first_name, last_name, and state, and a table named addresses that contains customer_id, state, city, zip, and street. Write a query that returns all customers last names with their state and zip. Assume that customer_id foreign key referencing customer_id in the customers table.

Given the table customers which contains columns customer_id, first_name, last_name, and state, and a table named addresses that contains customer_id, state, city, zip, and street. Write a query that returns all customers last names with their state and zip. Assume that customer_id foreign key referencing customer_id in the customers table.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter8: Advanced Sql

Section: Chapter Questions

Problem 3P

See similar textbooks