Write a SELECT statement that joins the Customers table to the Addresses table and returns these columns: first_name, last_name, line1, city, state, zip_code. Return one row for each address for the customer with an email address of [email protected]

The select statement to this question can be defined as below:

Statement:

SELECT first_name, last_name,

line1, city, state, zip_Code

FROM Customers JOIN Addresses ON

Customers.CustomerID = Addresses.CustomerID

WHERE Customers.EmailAddress = '[email protected]'.

Explanation:

Select declaration produces the data as a result of data set from more than one table. This statement collects 0 or even more rows from table, It also provides the view of the table.

it on google i find it on there

a) click on any cells in the range of data

b) click the data

c) click sort& filter group, click sort

d) select the column to sort by and then select a sort order

e) select the next column to sort by and select the sort order

f) click ok