SQL Query

Type your query here:

The main tables of interest in the database are called "places", "games", and "machines". The machine table refers to the "places" and "games" tables. There are also six small tables, called "machineconditions", "manufacturers", "admin", "system", "regions", and "placetypes". I know this is a very short description, but if you're going to experiment with your own SQL statements, I suppose you will be able to figure out how things fit together. The MySQL command "show tables", and "show columns from <table name>" are very helpful.