1. Other
  2. Other
  3. list the missions projectname missionno craftname and launchyear of all...

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
Blurred Solution
This question has been solved
Subscribe to see this solution