Display MissionID, the captain's Fullname, the ship's Model and Speed, the SolarSystem, the Distance and a calculated field TimeInYears (Distance ÷ Speed), rounded to 2 decimal places.
Database
XSpaceSystems
A private space exploration company assigning captains and spaceships to missions. Adapted from a real IEB exam.
Loading in-browser database…
Run your query to see results here.