Skip to content

Instantly share code, notes, and snippets.

@jacktator
Created May 11, 2017 03:44
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save jacktator/b107efbc524c8cbb8d176d774b321de3 to your computer and use it in GitHub Desktop.
UTS Database Fundamentals Quiz2 Answers 2017 Autumn
select days, count(*) as missions from nasa2_mission where days >=14 and projectname='Shuttle' group by days order by days;
select missionno, launchYear from nasa2_mission natural join nasa2_spacecraft where projectname = 'Shuttle' and launchyear = ( select min(launchyear) from nasa2_mission natural join nasa2_spacecraft where projectname='Shuttle' );
select ass1.astrono, ass1. missionno, ass2.missionno from nasa2_assigned ass1, nasa2_assigned ass2 where ass1.astrono=44 and ass1.projectname='Shuttle' and ass1.missionno!=ass2.missionno and ass2.projectname='Shuttle' and ass1.astrono = ass2.astrono;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment