-
Notifications
You must be signed in to change notification settings - Fork 0
/
expected-output.txt
182 lines (182 loc) · 11.5 KB
/
expected-output.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
+-----------------+
| |
+-----------------+
| **** Question 1 |
+-----------------+
+--------+-----------------------------+---------+-------------------+-----------+
| DeptID | DeptName | MajorID | MajorName | StartYear |
+--------+-----------------------------+---------+-------------------+-----------+
| COMP | Competition and Show | AGIL | Agility | 2021 |
| COMP | Competition and Show | SHOW | Showmanship | 2021 |
| COMP | Competition and Show | SLED | Sled Dog | 2022 |
| MILP | Military and Police Careers | BOMB | Bomb Detection | 2022 |
| MILP | Military and Police Careers | DRUG | Drug Detection | 2020 |
| MILP | Military and Police Careers | SECU | Security | 2020 |
| SERV | Service Careers | GUID | Guide Dog | 2021 |
| SERV | Service Careers | RESC | Search and Rescue | 2020 |
+--------+-----------------------------+---------+-------------------+-----------+
+-----------------+
| |
+-----------------+
| **** Question 2 |
+-----------------+
+--------+-----------------------------+---------+-------------------+-----------+
| DeptID | DeptName | MajorID | MajorName | StartYear |
+--------+-----------------------------+---------+-------------------+-----------+
| COMP | Competition and Show | AGIL | Agility | 2021 |
| COMP | Competition and Show | SHOW | Showmanship | 2021 |
| COMP | Competition and Show | SLED | Sled Dog | 2022 |
| FILM | Film and TV Careers | NULL | NULL | NULL |
| MILP | Military and Police Careers | BOMB | Bomb Detection | 2022 |
| MILP | Military and Police Careers | DRUG | Drug Detection | 2020 |
| MILP | Military and Police Careers | SECU | Security | 2020 |
| SERV | Service Careers | GUID | Guide Dog | 2021 |
| SERV | Service Careers | RESC | Search and Rescue | 2020 |
+--------+-----------------------------+---------+-------------------+-----------+
+-----------------+
| |
+-----------------+
| **** Question 3 |
+-----------------+
+--------+-----------------------------+-----------+
| DeptID | DeptName | NumMajors |
+--------+-----------------------------+-----------+
| COMP | Competition and Show | 3 |
| MILP | Military and Police Careers | 3 |
| SERV | Service Careers | 2 |
| FILM | Film and TV Careers | 0 |
+--------+-----------------------------+-----------+
+-----------------+
| |
+-----------------+
| **** Question 4 |
+-----------------+
+--------+-----------------------------+------------+------------+------------+------------+
| DeptID | DeptName | NumCourses | AvgCredits | MinCredits | MaxCredits |
+--------+-----------------------------+------------+------------+------------+------------+
| SERV | Service Careers | 10 | 3.5000 | 2 | 4 |
| COMP | Competition and Show | 9 | 2.8889 | 2 | 4 |
| MILP | Military and Police Careers | 8 | 3.5000 | 2 | 5 |
| FILM | Film and TV Careers | 0 | NULL | NULL | NULL |
+--------+-----------------------------+------------+------------+------------+------------+
+-----------------+
| |
+-----------------+
| **** Question 5 |
+-----------------+
+---------+----------------+
| MajorID | MajorName |
+---------+----------------+
| AGIL | Agility |
| BOMB | Bomb Detection |
| DRUG | Drug Detection |
| SHOW | Showmanship |
| SLED | Sled Dog |
+---------+----------------+
+-----------------+
| |
+-----------------+
| **** Question 6 |
+-----------------+
+--------+-----------------------------+
| DeptID | DeptName |
+--------+-----------------------------+
| COMP | Competition and Show |
| MILP | Military and Police Careers |
+--------+-----------------------------+
+-----------------+
| |
+-----------------+
| **** Question 7 |
+-----------------+
+-------+---------+--------------------------+
| DogID | DogName | Breed |
+-------+---------+--------------------------+
| 1 | Bertie | Beagle |
| 4 | Ozzie | Beagle |
| 6 | Peanut | Poodle |
| 7 | Orion | Poodle |
| 8 | Ivan | Siberian Husky |
| 11 | Charlie | Black Labrador Retriever |
| 15 | Alfie | Daschund |
| 16 | Charlie | Poodle |
| 19 | Lily | Havanese |
| 20 | Stella | Havanese |
+-------+---------+--------------------------+
+-----------------+
| |
+-----------------+
| **** Question 8 |
+-----------------+
+---------+-----------+------------+-------+---------+--------------------------+
| OwnerID | FirstName | LastName | DogID | DogName | Breed |
+---------+-----------+------------+-------+---------+--------------------------+
| 1 | Ruth | Kurniawati | 1 | Bertie | Beagle |
| 3 | Carol | Danvers | 4 | Ozzie | Beagle |
| 4 | Wade | Wilson | 6 | Peanut | Poodle |
| 4 | Wade | Wilson | 7 | Orion | Poodle |
| 4 | Wade | Wilson | 8 | Ivan | Siberian Husky |
| 5 | Anthony | Stark | 11 | Charlie | Black Labrador Retriever |
| 8 | Robert | Banner | 15 | Alfie | Daschund |
| 8 | Robert | Banner | 16 | Charlie | Poodle |
| 10 | T'Challa | Wakanda | 19 | Lily | Havanese |
| 10 | T'Challa | Wakanda | 20 | Stella | Havanese |
+---------+-----------+------------+-------+---------+--------------------------+
+-----------------+
| |
+-----------------+
| **** Question 9 |
+-----------------+
+---------+-------------------+--------+----------+----------------------------------------------------+------------+
| MajorID | MajorName | DeptID | CourseID | CourseName | NumCredits |
+---------+-------------------+--------+----------+----------------------------------------------------+------------+
| AGIL | Agility | COMP | 102 | Good Citizenship | 3 |
| AGIL | Agility | COMP | 160 | Ramps and Obstacles I: Basic Course | 4 |
| AGIL | Agility | COMP | 170 | Ramps and Obstacles II: Advanced Course | 4 |
| AGIL | Agility | COMP | 201 | Understanding Judges and Audience Behavior | 3 |
| BOMB | Bomb Detection | MILP | 101 | Basic Military Training | 4 |
| BOMB | Bomb Detection | MILP | 102 | Good Citizenship | 3 |
| BOMB | Bomb Detection | MILP | 120 | Basic Navigation | 4 |
| BOMB | Bomb Detection | MILP | 205 | Identification of Explosives | 3 |
| BOMB | Bomb Detection | MILP | 235 | Explosive Safety | 2 |
| DRUG | Drug Detection | MILP | 101 | Basic Military Training | 4 |
| DRUG | Drug Detection | MILP | 102 | Good Citizenship | 3 |
| DRUG | Drug Detection | MILP | 215 | Basic Identification of Food and Drug | 4 |
| DRUG | Drug Detection | MILP | 225 | Identification of Narcotics | 5 |
| GUID | Guide Dog | SERV | 102 | Good Citizenship | 3 |
| GUID | Guide Dog | SERV | 110 | Navigating Traffic | 3 |
| GUID | Guide Dog | SERV | 215 | Food and Drugs: Basic Identification and Signaling | 4 |
| RESC | Search and Rescue | SERV | 101 | Introduction to Search and Rescue | 2 |
| RESC | Search and Rescue | SERV | 102 | Good Citizenship | 3 |
| RESC | Search and Rescue | SERV | 160 | Navigating Obstacles and Rough Terrain | 4 |
| RESC | Search and Rescue | SERV | 180 | Identifying and Tracking Humans by Scent | 4 |
| RESC | Search and Rescue | SERV | 200 | Water Rescue | 4 |
| SECU | Security | MILP | 102 | Good Citizenship | 3 |
| SECU | Security | MILP | 205 | Introduction to Canine Psychology | 4 |
| SECU | Security | MILP | 215 | Food and Drugs: Basic Identification and Signaling | 4 |
| SHOW | Showmanship | COMP | 102 | Good Citizenship | 3 |
| SHOW | Showmanship | COMP | 130 | Walking the Ring | 3 |
| SHOW | Showmanship | COMP | 201 | Understanding Judges and Audience Behavior | 3 |
| SHOW | Showmanship | COMP | 207 | Introduction to Canine Fashion and Trends | 2 |
| SLED | Sled Dog | COMP | 160 | Ramps and Obstacles I: Basic Course | 4 |
| SLED | Sled Dog | COMP | 170 | Ramps and Obstacles II: Advanced Course | 4 |
| SLED | Sled Dog | COMP | 217 | Introduction to Sledding | 2 |
| SLED | Sled Dog | COMP | 227 | Advanced Sledding | 2 |
+---------+-------------------+--------+----------+----------------------------------------------------+------------+
+------------------+
| |
+------------------+
| **** Question 10 |
+------------------+
+---------+-------------------+--------+--------------------+--------------+
| MajorID | MajorName | DeptID | NumRequiredCourses | TotalCredits |
+---------+-------------------+--------+--------------------+--------------+
| RESC | Search and Rescue | SERV | 5 | 17 |
| BOMB | Bomb Detection | MILP | 5 | 16 |
| DRUG | Drug Detection | MILP | 4 | 16 |
| AGIL | Agility | COMP | 4 | 14 |
| SLED | Sled Dog | COMP | 4 | 12 |
| SHOW | Showmanship | COMP | 4 | 11 |
| SECU | Security | MILP | 3 | 11 |
| GUID | Guide Dog | SERV | 3 | 10 |
+---------+-------------------+--------+--------------------+--------------+