Show all students:
SQL is done successfully.
SQL is done successfully.
idfirstnamelastnameemailage
5SamJacksonjaniey1600@ggc.edu92
6SkylarSmithJarana78@ggc.edu19
7CatherineClarkHappybunny00@ggc.edu91
8MikeThomasTom23Car@ggc.edu19
9OaklandSamsonGreek34@ggc.edu76
10TaniaHerntonNiaWea2004@ggc.edu6
11JaylaJohnsonJay569@ggc.edu99
12AlexandriaBrownAlexLovessoccer15@ggc.edu82
13NariahKingNari147@ggc.edu10
14RodWaveStreetrunner45@ggc.edu1
17KateBrownKatie1236@ggc.edu74
18JannetKimpKdmm123@ggc.edu70
20SarahAppleAppShh@ggc.edu25
22GarryScottGrixx34@ggc.edu16
23Tanialarsonlarbear1299@ggc.edu2
24GrizzlyGGCabc@ggc.edu60
25MIchaelJamesmikey12@ggc.edu95
Change all students age to 21:
SQL is done successfully.
SQL is done successfully.
idfirstnamelastnameemailage
5SamJacksonjaniey1600@ggc.edu21
6SkylarSmithJarana78@ggc.edu21
7CatherineClarkHappybunny00@ggc.edu21
8MikeThomasTom23Car@ggc.edu21
9OaklandSamsonGreek34@ggc.edu21
10TaniaHerntonNiaWea2004@ggc.edu21
11JaylaJohnsonJay569@ggc.edu21
12AlexandriaBrownAlexLovessoccer15@ggc.edu21
13NariahKingNari147@ggc.edu21
14RodWaveStreetrunner45@ggc.edu21
17KateBrownKatie1236@ggc.edu21
18JannetKimpKdmm123@ggc.edu21
20SarahAppleAppShh@ggc.edu21
22GarryScottGrixx34@ggc.edu21
23Tanialarsonlarbear1299@ggc.edu21
24GrizzlyGGCabc@ggc.edu21
25MIchaelJamesmikey12@ggc.edu21
Change a few students age to be 19:
SQL is done successfully.
SQL is done successfully.
idfirstnamelastnameemailage
5SamJacksonjaniey1600@ggc.edu21
6SkylarSmithJarana78@ggc.edu19
7CatherineClarkHappybunny00@ggc.edu21
8MikeThomasTom23Car@ggc.edu19
9OaklandSamsonGreek34@ggc.edu21
10TaniaHerntonNiaWea2004@ggc.edu21
11JaylaJohnsonJay569@ggc.edu21
12AlexandriaBrownAlexLovessoccer15@ggc.edu21
13NariahKingNari147@ggc.edu21
14RodWaveStreetrunner45@ggc.edu21
17KateBrownKatie1236@ggc.edu21
18JannetKimpKdmm123@ggc.edu21
20SarahAppleAppShh@ggc.edu21
22GarryScottGrixx34@ggc.edu21
23Tanialarsonlarbear1299@ggc.edu21
24GrizzlyGGCabc@ggc.edu21
25MIchaelJamesmikey12@ggc.edu21
Change all students age to a random number between (1,100):
SQL is done successfully.
SQL is done successfully.
idfirstnamelastnameemailage
5SamJacksonjaniey1600@ggc.edu80
6SkylarSmithJarana78@ggc.edu19
7CatherineClarkHappybunny00@ggc.edu74
8MikeThomasTom23Car@ggc.edu19
9OaklandSamsonGreek34@ggc.edu27
10TaniaHerntonNiaWea2004@ggc.edu14
11JaylaJohnsonJay569@ggc.edu84
12AlexandriaBrownAlexLovessoccer15@ggc.edu83
13NariahKingNari147@ggc.edu64
14RodWaveStreetrunner45@ggc.edu66
17KateBrownKatie1236@ggc.edu42
18JannetKimpKdmm123@ggc.edu8
20SarahAppleAppShh@ggc.edu13
22GarryScottGrixx34@ggc.edu38
23Tanialarsonlarbear1299@ggc.edu54
24GrizzlyGGCabc@ggc.edu57
25MIchaelJamesmikey12@ggc.edu20
Find the total number of students:
SQL is done successfully.
Total # of students
17
Find the total number of students who are 40+ years old:
SQL is done successfully.
Total # of students who are 40+ years
9
Find the average age of all students :
SQL is done successfully.
Average age of all students
44.8235
Find the youngest and oldest students
SQL is done successfully.
Oldest age of all students Youngest age of all students
848
Sort in ascending order by lastname for all students:
SQL is done successfully.
idfirstnamelastnameemailage
20SarahAppleAppShh@ggc.edu13
17KateBrownKatie1236@ggc.edu42
12AlexandriaBrownAlexLovessoccer15@ggc.edu83
7CatherineClarkHappybunny00@ggc.edu74
24GrizzlyGGCabc@ggc.edu57
10TaniaHerntonNiaWea2004@ggc.edu14
5SamJacksonjaniey1600@ggc.edu80
25MIchaelJamesmikey12@ggc.edu20
11JaylaJohnsonJay569@ggc.edu84
18JannetKimpKdmm123@ggc.edu8
13NariahKingNari147@ggc.edu64
23Tanialarsonlarbear1299@ggc.edu54
9OaklandSamsonGreek34@ggc.edu27
22GarryScottGrixx34@ggc.edu38
6SkylarSmithJarana78@ggc.edu19
8MikeThomasTom23Car@ggc.edu19
14RodWaveStreetrunner45@ggc.edu66
Sort in descending order by lastname for students whose firstname is Tania:
SQL is done successfully.
idfirstnamelastnameemailage
23Tanialarsonlarbear1299@ggc.edu54
10TaniaHerntonNiaWea2004@ggc.edu14
Find how many Tania there are:
SQL is done successfully.
# of people whose name is Tania
2
Find how many people who have the same name and sort them in descending order by number of people:
SQL is done successfully.
firstnameNo_of_people_with_this_name
Tania2
Grizzly1
Skylar1
Mike1
Alexandria1
Rod1
Jannet1
Garry1
MIchael1
Sam1
Catherine1
Oakland1
Jayla1
Nariah1
Kate1
Sarah1
Find the youngest student:
SQL is done successfully.
idfirstnamelastnameage
18JannetKimp8
Find the oldest student:
SQL is done successfully.
idfirstnamelastnameage
11JaylaJohnson84
Find all the students who are older than the average age:
SQL is done successfully.
idfirstnamelastnameage
5SamJackson80
7CatherineClark74
11JaylaJohnson84
12AlexandriaBrown83
13NariahKing64
14RodWave66
23Tanialarson54
24GrizzlyGGC57