Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ╔═════╤════════════════╤════════════════╤═══════════╗
- ║ ID │ NAME │ TYPE │ LV ║
- ╟─────┼────────────────┼────────────────┼───────────╢
- ║ 1 │ Soyuz TMA-14 │ Soyuz │ Soyuz-FG ║
- ║ 2 │ Endeavour │ Space Shuttle │ Shuttle ║
- ║ 3 │ Soyuz TMA-15M │ Soyuz │ Soyuz-FG ║
- ║ 4 │ Atlantis │ Space Shuttle │ Shuttle ║
- ║ 5 │ Soyuz TM-31 │ Soyuz │ Soyuz-U ║
- ║ 6 │ EFT-1 │ Orion │ Delta-IV ║
- ║ 7 │ XXX │ CST-100 │ Delta-IV ║
- ║ 8 │ YYY │ CST-100 │ Falcon-9 ║
- ║ 9 │ ZZZ │ Dragon V2 │ Falcon-9 ║
- ║ ... │ ... │ ... │ ... ║
- ╚═════╧════════════════╧════════════════╧═══════════╝
- ╔═════╤════════════════╤═══════╤══════╗
- ║ ID │ NAME │ TYPE │ LV ║
- ╟─────┼────────────────┼───────┼──────╢
- ║ 1 │ Soyuz TMA-14 │ 1 │ 1 ║
- ║ 2 │ Endeavour │ 2 │ 2 ║
- ║ 3 │ Soyuz TMA-15M │ 1 │ 1 ║
- ║ 4 │ Atlantis │ 2 │ 2 ║
- ║ 5 │ Soyuz TM-31 │ 1 │ 3 ║
- ║ 6 │ EFT-1 │ 3 │ 4 ║
- ║ 7 │ XXX │ 4 │ 4 ║
- ║ 8 │ YYY │ 4 │ 5 ║
- ║ 9 │ ZZZ │ 5 │ 5 ║
- ║ ... │ ... │ ... │ ... ║
- ╚═════╧════════════════╧═══════╧══════╝
- ╔═════╤════════════════╗
- ║ ID │ TYPE ║
- ╟─────┼────────────────╢
- ║ 1 │ Soyuz ║
- ║ 2 │ Space Shuttle ║
- ║ 3 │ Orion ║
- ║ 4 │ CST-100 ║
- ║ 5 │ Dragon V2 ║
- ║ ... │ ... ║
- ╚═════╧════════════════╝
- ╔═════╤═══════════╗
- ║ ID │ LV ║
- ╟─────┼───────────╢
- ║ 1 │ Soyuz-FG ║
- ║ 2 │ Shuttle ║
- ║ 3 │ Soyuz-U ║
- ║ 4 │ Delta-IV ║
- ║ 5 │ Falcon-9 ║
- ║ ... │ ... ║
- ╚═════╧═══════════╝
- SELECT [Species] = T.Name,
- [Activity] = A.Name
- FROM Species S
- JOIN Taxonomy T
- ON S.SpeciesNo = T.TaxonomyNo
- JOIN SpeciesActivity SA
- ON S.SpeciesNo = SA.SpeciesNo
- JOIN Activity A
- ON SA.Activity = A.Activity
- SSTYPE
- SS_Code Name
- ------- -------------
- Sz Soyuz
- SS Space Shuttle
- Or Orion
- C1 CST-100
- D2 Dragon V2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement