MySQL-Database-with-Python-Frontend/query7.sql at main · exarchou/MySQL-Database-with-Python-Frontend · GitHub

Sitelet https://github.com/exarchou/MySQL-Database-with-Python-Frontend/blob/main/query7.sql

Repository navigation

4 lines (4 loc) · 315 Bytes

SELECT moon.MoonID AS ID, moon.Diameter AS Diameter
FROM moon JOIN planet ON moon.Planet_PlanetID = planet.PlanetID
		  JOIN planetarysystem ON planetarysystem.PlanetarySystemID = planet.PlanetarySystem_PlanetarySystemID
WHERE planetarysystem.Name = "Solar System" AND (moon.Mass > 3.5 OR moon.OrbitalDays > 35000);