SELECT COUNT(Reason),State FROM RMA INNER JOIN Orders ON RMA.OrderID=Orders.OrderID INNER JOIN Collaborators ON Orders.CustomerID=Collaborators.CollaboratorID WHERE Reason = 'Received returned equipment' GROUP BY State ORDER BY COUNT(Reason);

55 Oklahoma 55 Vermont 60 New Hampshire 64 Georgia 68 Florida 68 Illinois 70 Colorado 71 Kentucky 71 Pennsylvania 71 Nevada 72 Idaho 72 North Carolina 72 Nebraska 74 Oregon 75 Maryland 75 Louisiana 76 Alaska 76 Michigan 77 Mississippi 77 Connecticut 77 Minnesota 77 Washington 78 South Dakota 78 Hawaii 78 West Virginia 78 Missouri 78 Rhode Island 79 Ohio 80 Delaware 82 New Jersey 82 Texas 82 California 82 New Mexico 83 New York 83 Montana 83 Kansas 85 Arkansas 86 Tennessee 87 Indiana 88 Wyoming 88 South Carolina 88 Utah 88 Wisconsin 90 Iowa 90 North Dakota 90 Alabama 93 Maine 97 Arizona 135 Massachusetts

What I need is Items returned in state / Sold items in that state

mysql> describe Collaborators; - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - + - - - - - - + - - - - - + - - - - - - - - - + - - - - - - - + - - -- - - - - - - - - - + - - - - - -- - - - - + - - - - + - - - - - + - - - - - Field Type Null | Key | Default | Extra | ------+-------+ CollaboratorID | int(11) NO PRI NULL FirstName varchar(25) | YES NULL s | LastName | varchar (25) YES NULL Street varchar(50) | YESU NULL | City | varchar(50) | YEST | NULL State | varchar(25) | YEST | NULL ZipCode | int(11) YES | NULL | Telephone | varchar(15) | YEST NULL | - - - - - + - - - - - -- - - - - - - - - - + - - - - - - - - - - - - - + - - - - - - + - - - - - + - - - - - - - - - + 8 rows in set (0.03 sec) mysql> describe Orders; -- - - + | Field Type Null | Key Default Extra + - - - - - -- - - - - - - + - - - - - - - - - - - - - + - - - - - + - - - -- + - - - - - - - - - + - - - - - - - + OrderID CustomerID SKU Description | int(11) NO PRI | int(11) YES varchar(20) YES varchar(50) | YEST NULL NULL NULL NULL + - - - - - -- - - - - - - + - - - - - - - - - - - - - + - - - - - - + - - - - - + - - - - - - - - - + - - - - - - - + 4 rows in set (0.00 sec) mysql> Describe RMA: -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual mysql> Describe RMA; - - - - - - -- - + - - - - - - - - - - - - - - + - - - - - - + - - - - - + - - -- - - - - - + - - - - - - - + | Field Type Null Key Default | Extra - - - + - - - - +- - - - - - + PRI I RMAID OrderID Reason Status Step int(11) int(11) varchar(250) | varchar(50) varchar(15) NO YES YES YES YES NULL NULL NULL, NULL NULL | + - - - - -- - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - +- - - - - - - + 5 rows in set (0.00 sec)