ERROR 1054 (42S22): Unknown column ‘ship’ in ‘field list’
for mysql> SELECT ship.SHIPNUM, ship,SHIPNAME, avg(WEIGHT) FROM cruise JOIN ship ON cruise.SHIPNUM = ship.SHIPNUM JOIN visit ON cruise.CRUISENUM = visit.CRUISENUM WHERE visit.PORTNAME = “MIAMI”;