Activity 20 October Databases Continued

Show all students

SQL is done successfully.

id	firstname	lastname	email	age
2	Lindsey	Sabb	[email protected]	23
3	David	Mercado	[email protected]	12
5	Julio	Barroso	[email protected]	93
6	Sedina	Husanovic	[email protected]	27
7	Maria	Brichikov	[email protected]	60
8	Carina	George	[email protected]	16
10	Faisal	Badwan	[email protected]	1
11	Gabrielle	Bloomfield	[email protected]	59
12	Joseph	Klimenko	[email protected]	91
14	Lindsey	Sabb	[email protected]	77
15	David	Mercado	[email protected]	16
16	Tyree	King	[email protected]	48
17	Julio	Barroso	[email protected]	91
18	Sedina	Husanovic	[email protected]	12
19	Maria	Brichikov	[email protected]	87
20	Carina	George	[email protected]	0
22	Faisal	Badwan	[email protected]	40
23	Gabrielle	Bloomfield	[email protected]	0
24	Joseph	Klimenko	[email protected]	79
26	Lindsey	Sabb	[email protected]	95
27	David	Mercado	[email protected]	41
28	Tyree	King	[email protected]	20
29	Julio	Barroso	[email protected]	78
30	Sedina	Husanovic	[email protected]	30
31	Maria	Brichikov	[email protected]	15
32	Carina	George	[email protected]	88
34	Faisal	Badwan	[email protected]	93
35	Gabrielle	Bloomfield	[email protected]	2
36	Joseph	Klimenko	[email protected]	31
38	Lindsey	Sabb	[email protected]	50
39	David	Mercado	[email protected]	56
40	Tyree	King	[email protected]	31
41	Julio	Barroso	[email protected]	86
42	Sedina	Husanovic	[email protected]	40
43	Maria	Brichikov	[email protected]	43
44	Carina	George	[email protected]	93
46	Faisal	Badwan	[email protected]	38
47	Gabrielle	Bloomfield	[email protected]	12
48	Joseph	Klimenko	[email protected]	45
50	Lindsey	Sabb	[email protected]	89
51	David	Mercado	[email protected]	13
52	Tyree	King	[email protected]	97
53	Julio	Barroso	[email protected]	48
54	Sedina	Husanovic	[email protected]	49
55	Maria	Brichikov	[email protected]	1
56	Carina	George	[email protected]	57
58	Faisal	Badwan	[email protected]	85
59	Gabrielle	Bloomfield	[email protected]	56
60	Joseph	Klimenko	[email protected]	22
62	Lindsey	Sabb	[email protected]	45
63	David	Mercado	[email protected]	57
64	Tyree	King	[email protected]	50
65	Julio	Barroso	[email protected]	80
66	Sedina	Husanovic	[email protected]	52
67	Maria	Brichikov	[email protected]	19
68	Carina	George	[email protected]	41
70	Faisal	Badwan	[email protected]	48
71	Gabrielle	Bloomfield	[email protected]	19
72	Joseph	Klimenko	[email protected]	51

Total Rows: 59

Add age info for ALL STUDENTS

Error in running sql: ALTER TABLE Students ADD age INT(3) with error:Duplicate column name 'age'
SQL is done successfully.

id	firstname	lastname	email	age
2	Lindsey	Sabb	[email protected]	23
3	David	Mercado	[email protected]	12
5	Julio	Barroso	[email protected]	93
6	Sedina	Husanovic	[email protected]	27
7	Maria	Brichikov	[email protected]	60
8	Carina	George	[email protected]	16
10	Faisal	Badwan	[email protected]	1
11	Gabrielle	Bloomfield	[email protected]	59
12	Joseph	Klimenko	[email protected]	91
14	Lindsey	Sabb	[email protected]	77
15	David	Mercado	[email protected]	16
16	Tyree	King	[email protected]	48
17	Julio	Barroso	[email protected]	91
18	Sedina	Husanovic	[email protected]	12
19	Maria	Brichikov	[email protected]	87
20	Carina	George	[email protected]	0
22	Faisal	Badwan	[email protected]	40
23	Gabrielle	Bloomfield	[email protected]	0
24	Joseph	Klimenko	[email protected]	79
26	Lindsey	Sabb	[email protected]	95
27	David	Mercado	[email protected]	41
28	Tyree	King	[email protected]	20
29	Julio	Barroso	[email protected]	78
30	Sedina	Husanovic	[email protected]	30
31	Maria	Brichikov	[email protected]	15
32	Carina	George	[email protected]	88
34	Faisal	Badwan	[email protected]	93
35	Gabrielle	Bloomfield	[email protected]	2
36	Joseph	Klimenko	[email protected]	31
38	Lindsey	Sabb	[email protected]	50
39	David	Mercado	[email protected]	56
40	Tyree	King	[email protected]	31
41	Julio	Barroso	[email protected]	86
42	Sedina	Husanovic	[email protected]	40
43	Maria	Brichikov	[email protected]	43
44	Carina	George	[email protected]	93
46	Faisal	Badwan	[email protected]	38
47	Gabrielle	Bloomfield	[email protected]	12
48	Joseph	Klimenko	[email protected]	45
50	Lindsey	Sabb	[email protected]	89
51	David	Mercado	[email protected]	13
52	Tyree	King	[email protected]	97
53	Julio	Barroso	[email protected]	48
54	Sedina	Husanovic	[email protected]	49
55	Maria	Brichikov	[email protected]	1
56	Carina	George	[email protected]	57
58	Faisal	Badwan	[email protected]	85
59	Gabrielle	Bloomfield	[email protected]	56
60	Joseph	Klimenko	[email protected]	22
62	Lindsey	Sabb	[email protected]	45
63	David	Mercado	[email protected]	57
64	Tyree	King	[email protected]	50
65	Julio	Barroso	[email protected]	80
66	Sedina	Husanovic	[email protected]	52
67	Maria	Brichikov	[email protected]	19
68	Carina	George	[email protected]	41
70	Faisal	Badwan	[email protected]	48
71	Gabrielle	Bloomfield	[email protected]	19
72	Joseph	Klimenko	[email protected]	51

Total Rows: 59

Change all STUDENT ages to 21

SQL is done successfully.
SQL is done successfully.

id	firstname	lastname	email	age
2	Lindsey	Sabb	[email protected]	21
3	David	Mercado	[email protected]	21
5	Julio	Barroso	[email protected]	21
6	Sedina	Husanovic	[email protected]	21
7	Maria	Brichikov	[email protected]	21
8	Carina	George	[email protected]	21
10	Faisal	Badwan	[email protected]	21
11	Gabrielle	Bloomfield	[email protected]	21
12	Joseph	Klimenko	[email protected]	21
14	Lindsey	Sabb	[email protected]	21
15	David	Mercado	[email protected]	21
16	Tyree	King	[email protected]	21
17	Julio	Barroso	[email protected]	21
18	Sedina	Husanovic	[email protected]	21
19	Maria	Brichikov	[email protected]	21
20	Carina	George	[email protected]	21
22	Faisal	Badwan	[email protected]	21
23	Gabrielle	Bloomfield	[email protected]	21
24	Joseph	Klimenko	[email protected]	21
26	Lindsey	Sabb	[email protected]	21
27	David	Mercado	[email protected]	21
28	Tyree	King	[email protected]	21
29	Julio	Barroso	[email protected]	21
30	Sedina	Husanovic	[email protected]	21
31	Maria	Brichikov	[email protected]	21
32	Carina	George	[email protected]	21
34	Faisal	Badwan	[email protected]	21
35	Gabrielle	Bloomfield	[email protected]	21
36	Joseph	Klimenko	[email protected]	21
38	Lindsey	Sabb	[email protected]	21
39	David	Mercado	[email protected]	21
40	Tyree	King	[email protected]	21
41	Julio	Barroso	[email protected]	21
42	Sedina	Husanovic	[email protected]	21
43	Maria	Brichikov	[email protected]	21
44	Carina	George	[email protected]	21
46	Faisal	Badwan	[email protected]	21
47	Gabrielle	Bloomfield	[email protected]	21
48	Joseph	Klimenko	[email protected]	21
50	Lindsey	Sabb	[email protected]	21
51	David	Mercado	[email protected]	21
52	Tyree	King	[email protected]	21
53	Julio	Barroso	[email protected]	21
54	Sedina	Husanovic	[email protected]	21
55	Maria	Brichikov	[email protected]	21
56	Carina	George	[email protected]	21
58	Faisal	Badwan	[email protected]	21
59	Gabrielle	Bloomfield	[email protected]	21
60	Joseph	Klimenko	[email protected]	21
62	Lindsey	Sabb	[email protected]	21
63	David	Mercado	[email protected]	21
64	Tyree	King	[email protected]	21
65	Julio	Barroso	[email protected]	21
66	Sedina	Husanovic	[email protected]	21
67	Maria	Brichikov	[email protected]	21
68	Carina	George	[email protected]	21
70	Faisal	Badwan	[email protected]	21
71	Gabrielle	Bloomfield	[email protected]	21
72	Joseph	Klimenko	[email protected]	21

Total Rows: 59

Change SOME STUDENT ages to 19

SQL is done successfully.
SQL is done successfully.

id	firstname	lastname	email	age
2	Lindsey	Sabb	[email protected]	21
3	David	Mercado	[email protected]	21
5	Julio	Barroso	[email protected]	21
6	Sedina	Husanovic	[email protected]	21
7	Maria	Brichikov	[email protected]	21
8	Carina	George	[email protected]	21
10	Faisal	Badwan	[email protected]	21
11	Gabrielle	Bloomfield	[email protected]	21
12	Joseph	Klimenko	[email protected]	21
14	Lindsey	Sabb	[email protected]	21
15	David	Mercado	[email protected]	21
16	Tyree	King	[email protected]	21
17	Julio	Barroso	[email protected]	21
18	Sedina	Husanovic	[email protected]	21
19	Maria	Brichikov	[email protected]	21
20	Carina	George	[email protected]	21
22	Faisal	Badwan	[email protected]	21
23	Gabrielle	Bloomfield	[email protected]	21
24	Joseph	Klimenko	[email protected]	21
26	Lindsey	Sabb	[email protected]	21
27	David	Mercado	[email protected]	21
28	Tyree	King	[email protected]	21
29	Julio	Barroso	[email protected]	21
30	Sedina	Husanovic	[email protected]	21
31	Maria	Brichikov	[email protected]	21
32	Carina	George	[email protected]	21
34	Faisal	Badwan	[email protected]	21
35	Gabrielle	Bloomfield	[email protected]	21
36	Joseph	Klimenko	[email protected]	21
38	Lindsey	Sabb	[email protected]	21
39	David	Mercado	[email protected]	21
40	Tyree	King	[email protected]	21
41	Julio	Barroso	[email protected]	21
42	Sedina	Husanovic	[email protected]	21
43	Maria	Brichikov	[email protected]	21
44	Carina	George	[email protected]	21
46	Faisal	Badwan	[email protected]	21
47	Gabrielle	Bloomfield	[email protected]	21
48	Joseph	Klimenko	[email protected]	21
50	Lindsey	Sabb	[email protected]	21
51	David	Mercado	[email protected]	21
52	Tyree	King	[email protected]	21
53	Julio	Barroso	[email protected]	21
54	Sedina	Husanovic	[email protected]	21
55	Maria	Brichikov	[email protected]	21
56	Carina	George	[email protected]	21
58	Faisal	Badwan	[email protected]	21
59	Gabrielle	Bloomfield	[email protected]	21
60	Joseph	Klimenko	[email protected]	21
62	Lindsey	Sabb	[email protected]	21
63	David	Mercado	[email protected]	21
64	Tyree	King	[email protected]	21
65	Julio	Barroso	[email protected]	21
66	Sedina	Husanovic	[email protected]	21
67	Maria	Brichikov	[email protected]	21
68	Carina	George	[email protected]	21
70	Faisal	Badwan	[email protected]	21
71	Gabrielle	Bloomfield	[email protected]	21
72	Joseph	Klimenko	[email protected]	21

Total Rows: 59

Change STUDENT ages to Random # between 0 and 100

SQL is done successfully.
SQL is done successfully.

id	firstname	lastname	email	age
2	Lindsey	Sabb	[email protected]	79
3	David	Mercado	[email protected]	11
5	Julio	Barroso	[email protected]	17
6	Sedina	Husanovic	[email protected]	55
7	Maria	Brichikov	[email protected]	24
8	Carina	George	[email protected]	54
10	Faisal	Badwan	[email protected]	99
11	Gabrielle	Bloomfield	[email protected]	33
12	Joseph	Klimenko	[email protected]	68
14	Lindsey	Sabb	[email protected]	44
15	David	Mercado	[email protected]	14
16	Tyree	King	[email protected]	40
17	Julio	Barroso	[email protected]	58
18	Sedina	Husanovic	[email protected]	69
19	Maria	Brichikov	[email protected]	72
20	Carina	George	[email protected]	55
22	Faisal	Badwan	[email protected]	59
23	Gabrielle	Bloomfield	[email protected]	29
24	Joseph	Klimenko	[email protected]	70
26	Lindsey	Sabb	[email protected]	64
27	David	Mercado	[email protected]	11
28	Tyree	King	[email protected]	61
29	Julio	Barroso	[email protected]	72
30	Sedina	Husanovic	[email protected]	79
31	Maria	Brichikov	[email protected]	78
32	Carina	George	[email protected]	54
34	Faisal	Badwan	[email protected]	38
35	Gabrielle	Bloomfield	[email protected]	27
36	Joseph	Klimenko	[email protected]	24
38	Lindsey	Sabb	[email protected]	36
39	David	Mercado	[email protected]	10
40	Tyree	King	[email protected]	42
41	Julio	Barroso	[email protected]	81
42	Sedina	Husanovic	[email protected]	79
43	Maria	Brichikov	[email protected]	51
44	Carina	George	[email protected]	20
46	Faisal	Badwan	[email protected]	45
47	Gabrielle	Bloomfield	[email protected]	68
48	Joseph	Klimenko	[email protected]	6
50	Lindsey	Sabb	[email protected]	24
51	David	Mercado	[email protected]	2
52	Tyree	King	[email protected]	40
53	Julio	Barroso	[email protected]	94
54	Sedina	Husanovic	[email protected]	51
55	Maria	Brichikov	[email protected]	72
56	Carina	George	[email protected]	8
58	Faisal	Badwan	[email protected]	25
59	Gabrielle	Bloomfield	[email protected]	3
60	Joseph	Klimenko	[email protected]	38
62	Lindsey	Sabb	[email protected]	83
63	David	Mercado	[email protected]	3
64	Tyree	King	[email protected]	64
65	Julio	Barroso	[email protected]	12
66	Sedina	Husanovic	[email protected]	69
67	Maria	Brichikov	[email protected]	7
68	Carina	George	[email protected]	32
70	Faisal	Badwan	[email protected]	38
71	Gabrielle	Bloomfield	[email protected]	93
72	Joseph	Klimenko	[email protected]	54

Total Rows: 59

Remove a Student's Data

SQL is done successfully.
SQL is done successfully.

id	firstname	lastname	email	age
2	Lindsey	Sabb	[email protected]	79
3	David	Mercado	[email protected]	11
5	Julio	Barroso	[email protected]	17
6	Sedina	Husanovic	[email protected]	55
7	Maria	Brichikov	[email protected]	24
8	Carina	George	[email protected]	54
10	Faisal	Badwan	[email protected]	99
11	Gabrielle	Bloomfield	[email protected]	33
12	Joseph	Klimenko	[email protected]	68
14	Lindsey	Sabb	[email protected]	44
15	David	Mercado	[email protected]	14
16	Tyree	King	[email protected]	40
17	Julio	Barroso	[email protected]	58
18	Sedina	Husanovic	[email protected]	69
19	Maria	Brichikov	[email protected]	72
20	Carina	George	[email protected]	55
22	Faisal	Badwan	[email protected]	59
23	Gabrielle	Bloomfield	[email protected]	29
24	Joseph	Klimenko	[email protected]	70
26	Lindsey	Sabb	[email protected]	64
27	David	Mercado	[email protected]	11
28	Tyree	King	[email protected]	61
29	Julio	Barroso	[email protected]	72
30	Sedina	Husanovic	[email protected]	79
31	Maria	Brichikov	[email protected]	78
32	Carina	George	[email protected]	54
34	Faisal	Badwan	[email protected]	38
35	Gabrielle	Bloomfield	[email protected]	27
36	Joseph	Klimenko	[email protected]	24
38	Lindsey	Sabb	[email protected]	36
39	David	Mercado	[email protected]	10
40	Tyree	King	[email protected]	42
41	Julio	Barroso	[email protected]	81
42	Sedina	Husanovic	[email protected]	79
43	Maria	Brichikov	[email protected]	51
44	Carina	George	[email protected]	20
46	Faisal	Badwan	[email protected]	45
47	Gabrielle	Bloomfield	[email protected]	68
48	Joseph	Klimenko	[email protected]	6
50	Lindsey	Sabb	[email protected]	24
51	David	Mercado	[email protected]	2
52	Tyree	King	[email protected]	40
53	Julio	Barroso	[email protected]	94
54	Sedina	Husanovic	[email protected]	51
55	Maria	Brichikov	[email protected]	72
56	Carina	George	[email protected]	8
58	Faisal	Badwan	[email protected]	25
59	Gabrielle	Bloomfield	[email protected]	3
60	Joseph	Klimenko	[email protected]	38
62	Lindsey	Sabb	[email protected]	83
63	David	Mercado	[email protected]	3
64	Tyree	King	[email protected]	64
65	Julio	Barroso	[email protected]	12
66	Sedina	Husanovic	[email protected]	69
67	Maria	Brichikov	[email protected]	7
68	Carina	George	[email protected]	32
70	Faisal	Badwan	[email protected]	38
71	Gabrielle	Bloomfield	[email protected]	93
72	Joseph	Klimenko	[email protected]	54

Total Rows: 59

Remove a Student's reg_date Data

Error in running sql: ALTER TABLE Students DROP COLUMN reg_date; with error:Can't DROP 'reg_date'; check that column/key exists
SQL is done successfully.

id	firstname	lastname	email	age
2	Lindsey	Sabb	[email protected]	79
3	David	Mercado	[email protected]	11
5	Julio	Barroso	[email protected]	17
6	Sedina	Husanovic	[email protected]	55
7	Maria	Brichikov	[email protected]	24
8	Carina	George	[email protected]	54
10	Faisal	Badwan	[email protected]	99
11	Gabrielle	Bloomfield	[email protected]	33
12	Joseph	Klimenko	[email protected]	68
14	Lindsey	Sabb	[email protected]	44
15	David	Mercado	[email protected]	14
16	Tyree	King	[email protected]	40
17	Julio	Barroso	[email protected]	58
18	Sedina	Husanovic	[email protected]	69
19	Maria	Brichikov	[email protected]	72
20	Carina	George	[email protected]	55
22	Faisal	Badwan	[email protected]	59
23	Gabrielle	Bloomfield	[email protected]	29
24	Joseph	Klimenko	[email protected]	70
26	Lindsey	Sabb	[email protected]	64
27	David	Mercado	[email protected]	11
28	Tyree	King	[email protected]	61
29	Julio	Barroso	[email protected]	72
30	Sedina	Husanovic	[email protected]	79
31	Maria	Brichikov	[email protected]	78
32	Carina	George	[email protected]	54
34	Faisal	Badwan	[email protected]	38
35	Gabrielle	Bloomfield	[email protected]	27
36	Joseph	Klimenko	[email protected]	24
38	Lindsey	Sabb	[email protected]	36
39	David	Mercado	[email protected]	10
40	Tyree	King	[email protected]	42
41	Julio	Barroso	[email protected]	81
42	Sedina	Husanovic	[email protected]	79
43	Maria	Brichikov	[email protected]	51
44	Carina	George	[email protected]	20
46	Faisal	Badwan	[email protected]	45
47	Gabrielle	Bloomfield	[email protected]	68
48	Joseph	Klimenko	[email protected]	6
50	Lindsey	Sabb	[email protected]	24
51	David	Mercado	[email protected]	2
52	Tyree	King	[email protected]	40
53	Julio	Barroso	[email protected]	94
54	Sedina	Husanovic	[email protected]	51
55	Maria	Brichikov	[email protected]	72
56	Carina	George	[email protected]	8
58	Faisal	Badwan	[email protected]	25
59	Gabrielle	Bloomfield	[email protected]	3
60	Joseph	Klimenko	[email protected]	38
62	Lindsey	Sabb	[email protected]	83
63	David	Mercado	[email protected]	3
64	Tyree	King	[email protected]	64
65	Julio	Barroso	[email protected]	12
66	Sedina	Husanovic	[email protected]	69
67	Maria	Brichikov	[email protected]	7
68	Carina	George	[email protected]	32
70	Faisal	Badwan	[email protected]	38
71	Gabrielle	Bloomfield	[email protected]	93
72	Joseph	Klimenko	[email protected]	54

Total Rows: 59

Find total # of students

SQL is done successfully.

Total # of Students:
59

Total Rows: 1

WHERE AGE >=40

SQL is done successfully.

Total # of Students:
34

Total Rows: 1

Find average age of students

SQL is done successfully.

Average age of Students:
45.8983

Total Rows: 1

Find Highest/Lowest ages

SQL is done successfully.

Oldest age:	Youngest age
99	2

Total Rows: 1

Sort Descending by age

SQL is done successfully.

id	firstname	lastname	email	age
10	Faisal	Badwan	[email protected]	99
53	Julio	Barroso	[email protected]	94
71	Gabrielle	Bloomfield	[email protected]	93
62	Lindsey	Sabb	[email protected]	83
41	Julio	Barroso	[email protected]	81
2	Lindsey	Sabb	[email protected]	79
30	Sedina	Husanovic	[email protected]	79
42	Sedina	Husanovic	[email protected]	79
31	Maria	Brichikov	[email protected]	78
55	Maria	Brichikov	[email protected]	72
19	Maria	Brichikov	[email protected]	72
29	Julio	Barroso	[email protected]	72
24	Joseph	Klimenko	[email protected]	70
66	Sedina	Husanovic	[email protected]	69
18	Sedina	Husanovic	[email protected]	69
12	Joseph	Klimenko	[email protected]	68
47	Gabrielle	Bloomfield	[email protected]	68
26	Lindsey	Sabb	[email protected]	64
64	Tyree	King	[email protected]	64
28	Tyree	King	[email protected]	61
22	Faisal	Badwan	[email protected]	59
17	Julio	Barroso	[email protected]	58
20	Carina	George	[email protected]	55
6	Sedina	Husanovic	[email protected]	55
72	Joseph	Klimenko	[email protected]	54
32	Carina	George	[email protected]	54
8	Carina	George	[email protected]	54
54	Sedina	Husanovic	[email protected]	51
43	Maria	Brichikov	[email protected]	51
46	Faisal	Badwan	[email protected]	45
14	Lindsey	Sabb	[email protected]	44
40	Tyree	King	[email protected]	42
16	Tyree	King	[email protected]	40
52	Tyree	King	[email protected]	40
34	Faisal	Badwan	[email protected]	38
70	Faisal	Badwan	[email protected]	38
60	Joseph	Klimenko	[email protected]	38
38	Lindsey	Sabb	[email protected]	36
11	Gabrielle	Bloomfield	[email protected]	33
68	Carina	George	[email protected]	32
23	Gabrielle	Bloomfield	[email protected]	29
35	Gabrielle	Bloomfield	[email protected]	27
58	Faisal	Badwan	[email protected]	25
50	Lindsey	Sabb	[email protected]	24
7	Maria	Brichikov	[email protected]	24
36	Joseph	Klimenko	[email protected]	24
44	Carina	George	[email protected]	20
5	Julio	Barroso	[email protected]	17
15	David	Mercado	[email protected]	14
65	Julio	Barroso	[email protected]	12
3	David	Mercado	[email protected]	11
27	David	Mercado	[email protected]	11
39	David	Mercado	[email protected]	10
56	Carina	George	[email protected]	8
67	Maria	Brichikov	[email protected]	7
48	Joseph	Klimenko	[email protected]	6
63	David	Mercado	[email protected]	3
59	Gabrielle	Bloomfield	[email protected]	3
51	David	Mercado	[email protected]	2

Total Rows: 59

Sort ASC by firstname for ALL students *whose age is <50

SQL is done successfully.

id	firstname	lastname	email	age
68	Carina	George	[email protected]	32
56	Carina	George	[email protected]	8
44	Carina	George	[email protected]	20
3	David	Mercado	[email protected]	11
63	David	Mercado	[email protected]	3
15	David	Mercado	[email protected]	14
51	David	Mercado	[email protected]	2
27	David	Mercado	[email protected]	11
39	David	Mercado	[email protected]	10
70	Faisal	Badwan	[email protected]	38
58	Faisal	Badwan	[email protected]	25
46	Faisal	Badwan	[email protected]	45
34	Faisal	Badwan	[email protected]	38
35	Gabrielle	Bloomfield	[email protected]	27
11	Gabrielle	Bloomfield	[email protected]	33
23	Gabrielle	Bloomfield	[email protected]	29
59	Gabrielle	Bloomfield	[email protected]	3
36	Joseph	Klimenko	[email protected]	24
48	Joseph	Klimenko	[email protected]	6
60	Joseph	Klimenko	[email protected]	38
5	Julio	Barroso	[email protected]	17
65	Julio	Barroso	[email protected]	12
14	Lindsey	Sabb	[email protected]	44
50	Lindsey	Sabb	[email protected]	24
38	Lindsey	Sabb	[email protected]	36
67	Maria	Brichikov	[email protected]	7
7	Maria	Brichikov	[email protected]	24
16	Tyree	King	[email protected]	40
52	Tyree	King	[email protected]	40
40	Tyree	King	[email protected]	42

Total Rows: 30

Find # of 'Davids'

SQL is done successfully.

# of Davids:
6

Total Rows: 1

Group by firstname and order by # of occurences

SQL is done successfully.

firstname	No_of_people_with_this_name
Lindsey	6
David	6
Julio	6
Sedina	6
Maria	6
Carina	6
Faisal	6
Gabrielle	6
Joseph	6
Tyree	5

Total Rows: 10

Find youngest Student(s)

SQL is done successfully.

id	firstname	lastname	age
51	David	Mercado	2

Total Rows: 1

Find oldest Student(s) who are older than the Average age

SQL is done successfully.

id	firstname	lastname	age
2	Lindsey	Sabb	79
6	Sedina	Husanovic	55
8	Carina	George	54
10	Faisal	Badwan	99
12	Joseph	Klimenko	68
17	Julio	Barroso	58
18	Sedina	Husanovic	69
19	Maria	Brichikov	72
20	Carina	George	55
22	Faisal	Badwan	59
24	Joseph	Klimenko	70
26	Lindsey	Sabb	64
28	Tyree	King	61
29	Julio	Barroso	72
30	Sedina	Husanovic	79
31	Maria	Brichikov	78
32	Carina	George	54
41	Julio	Barroso	81
42	Sedina	Husanovic	79
43	Maria	Brichikov	51
47	Gabrielle	Bloomfield	68
53	Julio	Barroso	94
54	Sedina	Husanovic	51
55	Maria	Brichikov	72
62	Lindsey	Sabb	83
64	Tyree	King	64
66	Sedina	Husanovic	69
71	Gabrielle	Bloomfield	93
72	Joseph	Klimenko	54

Total Rows: 29