Querying Data from the Database

Welcome to the querying assignment! In this part of the course, you will practice writing SQL queries to retrieve data from the database you set up earlier.

Specifically, you'll be working with three tables: Customers, Orders, and RMA. Your task is to write an SQL query to select all of the customers located in the state of Massachusetts.

Table: Customers

This table stores information about customers and their contact details.

Field $($DataType$)$

$-$ CustomerID $($INT$,$ Primary Key$)$

$-$ FirstName $($VARCHAR$(50))$

$-$ LastName $($VARCHAR$(50))$

$-$ Street$($ VARCHAR$(100)$

$-$ City $($VARCHAR$(50))$

$-$ State $($VARCHAR$(50))$

$-$ ZipCode $($VARCHAR$(10))$

$-$ Telephone $($VARCHAR$(15))$

Table: Orders

This table stores information about customer orders and their associated products.

Field $($DataType$)$

$-$ TypeOrderID $($INT$,$ Primary Key$)$

$-$ CustomerID $($INT$,$ VARCHAR$(50))$

$-$ Description $($VARCHAR$(100))$

Table: RMA

This table stores information about return merchandise authorizations $($RMAs$)$ related to customer orders.

Field $($DataType$)$

$-$ TypeRMAID $($INT$,$ Primary Key$)$

$-$ OrderID $($INT$)$