/////////////////////////////task2/////////////////////////////////

Home | Task 1 | Task 2 | Task 3 | Task 4 |

Member Table

MemberIDMemberNameMemberEmail
1231Cloud MachabeCloud.Machabe@gmail.com
1234Deon MathebulaDeon.Mathebula@gmail.com
1235Sheldon MachabeSheldon.Machabe@gmail.com
1236Akilah MachabeAkilah.Machabe@gmail.com
1237Makwande MachabeMakwande.Machabe@gmail.com
1239NtiyisoNtiyiso.M@gmail.com
1240CharlesCharles@gmail.com
1241NandiNandi@gmail.com
1242An Testtest@test.com
1243hVIOKORcBpnMfmohdirwan97@yahoo.com
1244mnWRFEusztriciae2z8a03ie@outlook.com
1245WLUUtIZiivromenbrozyna@yahoo.com
1246zKchBIcBNQqdenyaweissv600@gmail.com
1247MRYjKItnbwjqxhsrxitb@yahoo.com
1248ecTvWJitj3scf39f0cgi0aq@yahoo.com
1249bFHvHdJUsteelegeib1985@gmail.com
1250CVydpSGFicbjnxgnqeyys@yahoo.com
1251ARRgaeVdPTSBtnamtwdsmvsgggq@yahoo.com

Group Table

GroupIDGroupNameGroupDescription
101201IT OPSAdministrators of the Operations
101203PlatformsAdministrators of the Platforms
101205HumanitiesAdministrators of the human management
101206SystemsAdministrators of the system

MemberGroup Table

MemberIDGroupIDJoiningDate
12311012012024-10-31
12341012021988-12-10
12351012031991-08-25
12361012042024-07-14
12371012052023-09-18

Add a member

Name:
Email:

Modify membergroup

MemberID:
GroupID:
Joining Date:

Delete a group

GroupID:

Run SELECT Queries

SELECT * FROM member ORDER BY MemberName
SELECT * FROM member WHERE MemberName LIKE '%cloud%'
SELECT Member.MemberName, `Group`.GroupName FROM Member INNER JOIN MemberGroup ON Member.MemberID = MemberGroup.MemberID INNER JOIN `Group` ON MemberGroup.GroupID = `Group`.GroupID
SELECT * FROM member LIMIT 3
SELECT MAX(MemberID) AS MaxMemberID FROM Member