------ 5 ------
SELECT card_number, job_during_journey
FROM travel_cards
ORDER BY card_number ASC;
------ 6 ------
SELECT id,
CONCAT(first_name, ' ', last_name) AS full_name,
ucn
FROM colonists
ORDER BY first_name ASC, last_name ASC, id ASC;
------ 7 ------
SELECT id, journey_start, journey_end
FROM journeys
WHERE purpose = 'Military'
ORDER BY journey_start ASC
------ 8 ------
SELECT c.id,
concat(c.first_name, ' ', c.last_name) AS full_name
 FROM travel_cards AS tc
INNER JOIN colonists AS c
ON tc.colonist_id = c.id
WHERE job_during_journey = 'Pilot'
ORDER BY c.id ASC;
------ 9 ------
SELECT
ss.name AS spaceship_name,
sp.name AS spaceport_name
FROM journeys AS j
INNER JOIN spaceports AS sp
ON j.destination_spaceport_id = sp.id
INNER JOIN spaceships AS ss
ON j.spaceship_id = ss.id
ORDER BY light_speed_rate DESC
LIMIT 1
------ 10 ------
SELECT
p.name AS planet_name,
COUNT(*) AS journeys_count
 FROM journeys AS j
INNER JOIN spaceports AS sp
ON sp.id = j.destination_spaceport_id
INNER JOIN planets AS p
ON sp.planet_id = p.id
GROUP BY p.id
ORDER BY journeys_count DESC,
planet_name ASC
------ 11 ------
SELECT
p.name AS planet_name,
COUNT(*) AS journeys_count
 FROM journeys AS j
INNER JOIN spaceports AS sp
ON sp.id = j.destination_spaceport_id
INNER JOIN planets AS p
ON sp.planet_id = p.id
GROUP BY p.id
ORDER BY journeys_count DESC,
planet_name ASC