sql1

SELECT DISTINCT nameShip.name, Classes.displacement, Classes.numGuns
FROM Classes LEFT JOIN
    (SELECT Outcomes.ship AS name , Ships.class  AS class
     FROM Outcomes LEFT JOIN
      Ships ON Ships.name = Outcomes.ship
     WHERE Outcomes.battle = 'Guadalcanal'
    ) AS nameShip
 ON nameShip.class = Classes.class

inputStr = INPUT()
matrix0 =[]
while inputStr != "end":
  matrix0.append([INT(i) FOR i IN inputStr.split()])
  inputStr = INPUT()
print(matrix0)
IF len(matrix0) == 0:
  exit
X, Y = len(matrix0[0]), len(matrix0)
matrix1 = [[0] * X FOR k IN range(Y)]
print(matrix1)

FOR y IN range(Y):
  FOR x IN range(X):
    FOR dx IN range(-1, 2):
      FOR dy IN range(-1, 2):
        xdx = x + dx
        ydy = y + dy
        IF 0 <= xdx < X AND 0 <= ydy < Y AND :
          print(matrix0[xdx][ydy])
          matrix1[x][y] += matrix0[xdx][ydy]
print(matrix1)