Question: list the missions projectname missionno craftname and launchyear of all...
Question details
List the missions (projectname, missionno), craftname, and launchYear of all missions launched after 1960 by any projectname called “Mercury”. Order by the mission no. With the given data, the result of the (correct) query will be:
| projectname | missionno | craftname | launchyear | |
| Mercury | 1 | Freedom 7 | 1961 | |
| Mercury | 2 | Liberty Bell 7 | 1961 | |
| Mercury | 3 | Friendshi 7 | 1962 | |
| Mercury | 4 | Aurora 7 | 1962 | |
| Mercury | 5 | Sigma 7 | 1962 | |
|
Mercury (6 rows) |
6 | Faith 7 | 1963 |
Solution by an expert tutor
