Show all students:
SQL is done successfully.
SQL is done successfully.
| id | firstname | lastname | email | age |
|---|
| 5 | Sam | Jackson | janiey1600@ggc.edu | 92 |
| 6 | Skylar | Smith | Jarana78@ggc.edu | 19 |
| 7 | Catherine | Clark | Happybunny00@ggc.edu | 91 |
| 8 | Mike | Thomas | Tom23Car@ggc.edu | 19 |
| 9 | Oakland | Samson | Greek34@ggc.edu | 76 |
| 10 | Tania | Hernton | NiaWea2004@ggc.edu | 6 |
| 11 | Jayla | Johnson | Jay569@ggc.edu | 99 |
| 12 | Alexandria | Brown | AlexLovessoccer15@ggc.edu | 82 |
| 13 | Nariah | King | Nari147@ggc.edu | 10 |
| 14 | Rod | Wave | Streetrunner45@ggc.edu | 1 |
| 17 | Kate | Brown | Katie1236@ggc.edu | 74 |
| 18 | Jannet | Kimp | Kdmm123@ggc.edu | 70 |
| 20 | Sarah | Apple | AppShh@ggc.edu | 25 |
| 22 | Garry | Scott | Grixx34@ggc.edu | 16 |
| 23 | Tania | larson | larbear1299@ggc.edu | 2 |
| 24 | Grizzly | GGC | abc@ggc.edu | 60 |
| 25 | MIchael | James | mikey12@ggc.edu | 95 |
Change all students age to 21:
SQL is done successfully.
SQL is done successfully.
| id | firstname | lastname | email | age |
|---|
| 5 | Sam | Jackson | janiey1600@ggc.edu | 21 |
| 6 | Skylar | Smith | Jarana78@ggc.edu | 21 |
| 7 | Catherine | Clark | Happybunny00@ggc.edu | 21 |
| 8 | Mike | Thomas | Tom23Car@ggc.edu | 21 |
| 9 | Oakland | Samson | Greek34@ggc.edu | 21 |
| 10 | Tania | Hernton | NiaWea2004@ggc.edu | 21 |
| 11 | Jayla | Johnson | Jay569@ggc.edu | 21 |
| 12 | Alexandria | Brown | AlexLovessoccer15@ggc.edu | 21 |
| 13 | Nariah | King | Nari147@ggc.edu | 21 |
| 14 | Rod | Wave | Streetrunner45@ggc.edu | 21 |
| 17 | Kate | Brown | Katie1236@ggc.edu | 21 |
| 18 | Jannet | Kimp | Kdmm123@ggc.edu | 21 |
| 20 | Sarah | Apple | AppShh@ggc.edu | 21 |
| 22 | Garry | Scott | Grixx34@ggc.edu | 21 |
| 23 | Tania | larson | larbear1299@ggc.edu | 21 |
| 24 | Grizzly | GGC | abc@ggc.edu | 21 |
| 25 | MIchael | James | mikey12@ggc.edu | 21 |
Change a few students age to be 19:
SQL is done successfully.
SQL is done successfully.
| id | firstname | lastname | email | age |
|---|
| 5 | Sam | Jackson | janiey1600@ggc.edu | 21 |
| 6 | Skylar | Smith | Jarana78@ggc.edu | 19 |
| 7 | Catherine | Clark | Happybunny00@ggc.edu | 21 |
| 8 | Mike | Thomas | Tom23Car@ggc.edu | 19 |
| 9 | Oakland | Samson | Greek34@ggc.edu | 21 |
| 10 | Tania | Hernton | NiaWea2004@ggc.edu | 21 |
| 11 | Jayla | Johnson | Jay569@ggc.edu | 21 |
| 12 | Alexandria | Brown | AlexLovessoccer15@ggc.edu | 21 |
| 13 | Nariah | King | Nari147@ggc.edu | 21 |
| 14 | Rod | Wave | Streetrunner45@ggc.edu | 21 |
| 17 | Kate | Brown | Katie1236@ggc.edu | 21 |
| 18 | Jannet | Kimp | Kdmm123@ggc.edu | 21 |
| 20 | Sarah | Apple | AppShh@ggc.edu | 21 |
| 22 | Garry | Scott | Grixx34@ggc.edu | 21 |
| 23 | Tania | larson | larbear1299@ggc.edu | 21 |
| 24 | Grizzly | GGC | abc@ggc.edu | 21 |
| 25 | MIchael | James | mikey12@ggc.edu | 21 |
Change all students age to a random number between (1,100):
SQL is done successfully.
SQL is done successfully.
| id | firstname | lastname | email | age |
|---|
| 5 | Sam | Jackson | janiey1600@ggc.edu | 80 |
| 6 | Skylar | Smith | Jarana78@ggc.edu | 19 |
| 7 | Catherine | Clark | Happybunny00@ggc.edu | 74 |
| 8 | Mike | Thomas | Tom23Car@ggc.edu | 19 |
| 9 | Oakland | Samson | Greek34@ggc.edu | 27 |
| 10 | Tania | Hernton | NiaWea2004@ggc.edu | 14 |
| 11 | Jayla | Johnson | Jay569@ggc.edu | 84 |
| 12 | Alexandria | Brown | AlexLovessoccer15@ggc.edu | 83 |
| 13 | Nariah | King | Nari147@ggc.edu | 64 |
| 14 | Rod | Wave | Streetrunner45@ggc.edu | 66 |
| 17 | Kate | Brown | Katie1236@ggc.edu | 42 |
| 18 | Jannet | Kimp | Kdmm123@ggc.edu | 8 |
| 20 | Sarah | Apple | AppShh@ggc.edu | 13 |
| 22 | Garry | Scott | Grixx34@ggc.edu | 38 |
| 23 | Tania | larson | larbear1299@ggc.edu | 54 |
| 24 | Grizzly | GGC | abc@ggc.edu | 57 |
| 25 | MIchael | James | mikey12@ggc.edu | 20 |
Find the total number of students:
SQL is done successfully.
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 |
|---|
| 84 | 8 |
Sort in ascending order by lastname for all students:
SQL is done successfully.
| id | firstname | lastname | email | age |
|---|
| 20 | Sarah | Apple | AppShh@ggc.edu | 13 |
| 17 | Kate | Brown | Katie1236@ggc.edu | 42 |
| 12 | Alexandria | Brown | AlexLovessoccer15@ggc.edu | 83 |
| 7 | Catherine | Clark | Happybunny00@ggc.edu | 74 |
| 24 | Grizzly | GGC | abc@ggc.edu | 57 |
| 10 | Tania | Hernton | NiaWea2004@ggc.edu | 14 |
| 5 | Sam | Jackson | janiey1600@ggc.edu | 80 |
| 25 | MIchael | James | mikey12@ggc.edu | 20 |
| 11 | Jayla | Johnson | Jay569@ggc.edu | 84 |
| 18 | Jannet | Kimp | Kdmm123@ggc.edu | 8 |
| 13 | Nariah | King | Nari147@ggc.edu | 64 |
| 23 | Tania | larson | larbear1299@ggc.edu | 54 |
| 9 | Oakland | Samson | Greek34@ggc.edu | 27 |
| 22 | Garry | Scott | Grixx34@ggc.edu | 38 |
| 6 | Skylar | Smith | Jarana78@ggc.edu | 19 |
| 8 | Mike | Thomas | Tom23Car@ggc.edu | 19 |
| 14 | Rod | Wave | Streetrunner45@ggc.edu | 66 |
Sort in descending order by lastname for students whose firstname is Tania:
SQL is done successfully.
| id | firstname | lastname | email | age |
|---|
| 23 | Tania | larson | larbear1299@ggc.edu | 54 |
| 10 | Tania | Hernton | NiaWea2004@ggc.edu | 14 |
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.
| firstname | No_of_people_with_this_name |
|---|
| Tania | 2 |
| Grizzly | 1 |
| Skylar | 1 |
| Mike | 1 |
| Alexandria | 1 |
| Rod | 1 |
| Jannet | 1 |
| Garry | 1 |
| MIchael | 1 |
| Sam | 1 |
| Catherine | 1 |
| Oakland | 1 |
| Jayla | 1 |
| Nariah | 1 |
| Kate | 1 |
| Sarah | 1 |
Find the youngest student:
SQL is done successfully.
| id | firstname | lastname | age |
|---|
| 18 | Jannet | Kimp | 8 |
Find the oldest student:
SQL is done successfully.
| id | firstname | lastname | age |
|---|
| 11 | Jayla | Johnson | 84 |
Find all the students who are older than the average age:
SQL is done successfully.
| id | firstname | lastname | age |
|---|
| 5 | Sam | Jackson | 80 |
| 7 | Catherine | Clark | 74 |
| 11 | Jayla | Johnson | 84 |
| 12 | Alexandria | Brown | 83 |
| 13 | Nariah | King | 64 |
| 14 | Rod | Wave | 66 |
| 23 | Tania | larson | 54 |
| 24 | Grizzly | GGC | 57 |