A company has the following two data tables in the database.

CUSTOMER

ID

NAME

CITY

STATE

$100558$

Walmart

Bentonville

AR

$100623$

Target

Minneapolis

MN

$100879$

Trader Joe's

Monrovia

CA

$100950$

Sam's Club

Bentonville

AR

CUSTOMER$\_$COUNT

STATE

NO$\_$OF$\_$CUSTOMER

MN

$1$

CA

$1$

AR

$2$

Assume that your manager asked you to inner join these two tables together for further reporting purposes. If you are using Microsoft SQL Server Management Studio, please complete the following SQL queries to merge the two tables. $($Note: Please use all CAPITAL LETTERS for the SQL queries. For example, use "SELECT", instead of "select" or "Select".$)$

SELECT $*$

FROM CUSTOMER

ON CUSTOMER.STATE$=$CUSTOMER$\_$COUNT.STATE