List the missions (project name, mission no) and launch Year of all missions launched before 1990...

 

Transcribed Image Text:

List the missions (project name, mission no) and launch Year of all missions launched before 1990 by any spacecraft called "Columbia". Order by the launch year. With the given data, the result of the (correct) query will be: project name | mission no | launch year Apollo | 11 | 1969 Shuttle | STS-1 | 1981 Shuttle | STS-2 | 1981 Shuttle STS-3 | 1982 Shuttle | STS-4 | 1982 Shuttle | STS-5 | 1982 Shuttle | STS-9 | 1983 Shuttle STS-61C | 1986 Shuttle | STS-28 | 1989 Once you finish executing your query using ED, capture the output via snip tool or screenshot and paste it into a word document along with the SQL used to produce that result. List the missions (project name, mission no) and launch Year of all missions launched before 1990 by any spacecraft called "Columbia". Order by the launch year. With the given data, the result of the (correct) query will be: project name | mission no | launch year Apollo | 11 | 1969 Shuttle | STS-1 | 1981 Shuttle | STS-2 | 1981 Shuttle STS-3 | 1982 Shuttle | STS-4 | 1982 Shuttle | STS-5 | 1982 Shuttle | STS-9 | 1983 Shuttle STS-61C | 1986 Shuttle | STS-28 | 1989 Once you finish executing your query using ED, capture the output via snip tool or screenshot and paste it into a word document along with the SQL used to produce that result.

Answer rating: 100% (QA)

You can use this query in a SQL database management tool such as MySQL Workbench or phpMyAd... View the full answer