Laramie Park District has files of participants in its summer and winter program
ID: 667852 • Letter: L
Question
Laramie Park District has files of participants in its summer and winter programs this year. Each file is in participant ID number order and contains additional fields for first name, last name, age and class taken (for example Beginning Swimming).
Design the logic for a program, using pseudocode, that merges the files for summer and winter programs to create a list of the first and last names of all participants for the year in ID number order.
Laramie Park Summer participants:
101, Amanda, Carter, 11, Beginning Swimming
103, Brian, Morrison, 7, Beginning Karate
105, Justin, Newburg, 10, Rollerblading
106, Marlene, Kennedy, 9, Beginning Swimming
106, Marlene, Kennedy, 9, Beginning Tennis
109, Eli, Thomas, 7, Beginning Karate
109, Eli, Thomas, 10, Rollerblading
109, Eli, Thomas, 10, Beginning Tennis
110, Anna, Cravitz, 8, Beginning Swimming
Laramie Park winter participants:
102, Walter, Donaldson, 11, Beginning Karate
103, Brian, Morrison, 7, Advanced Karate
105, Justin, Newburg, 10, Oil Painting
106, Marlene, Kennedy, 9, Ice Skating
107, Henry, Young, 11, Oil Painting
107, Henry, Young, 11, Ice Skating
108, Sally, Rhodes, 7, Ice Skating
109, Eli, Thomas, 10, Ice Skating
109, Eli, Thomas, 10, Ice Hockey
111, Savannah, Dylan, 11, Ice Hockey
Explanation / Answer
The following query will result a list of the first and last names of all participants for the year in ID number order.
Select firstname , lastname
from summer, winter
order by id number asc;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.