Q1
Table 1
GPA
First Name |
Last Name |
Major |
GPA |
Jose |
Azcona |
Finance |
2.5 |
Reginald |
Raphael |
Art |
2.6 |
Jamille |
Rose |
Accounting |
2.9 |
Andre |
Armor |
Art |
3.0 |
Edwin |
Sanchez |
Psychology |
3.1 |
Korina |
Cruz` |
Biology |
3.2 |
Brenda |
Pedersen |
Finance |
3.3 |
Rebecca |
Matthews |
Finance |
3.5 |
Table 2
Student info
Social Security |
Last Name |
First Name |
Age |
Telephone Number |
123-46-6566 |
Matthews |
Rebecca` |
21 |
(347)
697-0735 |
542-84-5624 |
Rose |
Jamille |
22 |
(547)
545-2536 |
542-87-5752 |
Raphael |
Reginald |
22 |
(347)
256-0353 |
574-18-8956 |
Sanchez |
Edwin |
22 |
(547)
833-2664 |
845-24-5652 |
Pedersen |
Brenda |
22 |
(917)
968-5008 |
874-42-1545 |
Armor |
Andre |
23 |
(718)
359-7466 |
875-41-2433 |
Cruz |
Korina |
21 |
(646)
641-0354 |
942-74-5642 |
Azcona |
Jose |
21 |
(973)
542-4125 |
Q1a
Table 1
Table 2
Q1b
Q1c
SELECT Years.Year, [Student info].Age, [School Record].Major,
[School Record].[First Name]
FROM (Years INNER JOIN [Student info] ON Years.[First Name] = [Student
info].[First Name]) INNER JOIN [School Record] ON Years.[Last Name] =
[School Record].[Last Name]
WHERE (((Years.Year)="senior") AND (([Student info].Age)>21));
quiery2 21nover
Year |
Age |
Major |
First Name |
Senior |
22 |
Accounting |
Jamille |
Q1d
Table before Update
Student info
Social Security |
Last Name |
First Name |
Age |
Telephone Number |
123-46-6566 |
Matthews |
Rebecca` |
21 |
(347)
697-0735 |
542-84-5624 |
Rose |
Jamille |
22 |
(547)
545-2536 |
542-87-5752 |
Raphael |
Reginald |
22 |
(347)
256-0353 |
574-18-8956 |
Sanchez |
Edwin |
22 |
(547)
833-2664 |
845-24-5652 |
Pedersen |
Brenda |
22 |
(917)
968-5008 |
874-42-1545 |
Armor |
Andre |
23 |
(718)
359-7466 |
875-41-2433 |
Cruz |
Korina |
21 |
(646)
641-0354 |
942-74-5642 |
Azcona |
Jose |
21 |
(973)
542-4125 |
|