10 95 Ali Holmes
2002-04-26 Female 212-2326 Enim Av.
1747 Ireland
MC
Picture 2.1
Zoom
Question 3:
Write a query to display enrollmentld, courseld, semesterld, studentld, name, country,department corresponding to all enrollments of all students who are from 'Italy' as follows:
enrollmentld
courseld
semesterld
studentld
name
country
department
1
1
1
1
1
Stacey Payne Italy SE
2
258
4
8
1
Stacey Payne Italy SE
3
115
7
3
1
Stacey Payne Italy SE
4
149
9
4
1
Stacey Payne Italy SE
5
91
12
22
1
Stacey Payne Italy SE
6
214
14
21
1
Stacey Payne Italy SE
7
38
4
19
7
Calvin Elliott Italy SE
8
96
6
24
7
Calvin Elliott Italy SE Calvin Elliott Italy
9
33
10
15
7
SE
10 157
11
17
7
Calvin Elliott Italy SE
11 138
11
19
7
Calvin Elliott Italy SE
Picture 3.1
Question 4:
Write a query to display courseld, CourseCode, title of all distinct courses which were enrolled by any female student in the semesters 'Fa2019' or 'Fa2019_B5' as follows:
+ 100%
Close
