Give the SQL statements output for the following data reque

Give the SQL statements & output for the following data requests:


Which customers live in New Jersey? List each customer\'s last name, first name, and state.

Solution

Answer:

Below query will pull the data of the customer who lives in New Jersey

select last_name, first_name, state from customer where state = \"New Jersey\";