SELECT * FROM `Sample_Data` WHERE email LIKE '%@%.%'
id: 3 - Name: John Junior
id: 4 - Name: John Sophomore
id: 5 - Name: Mary Freshman
id: 10 - Name: ryan Sophomore


SELECT id, username, email FROM Sample_Data WHERE username BETWEEN 'ad' and 'k'
id: 1 - Name: as Email: asdf
id: 2 - Name: asdf Email: asdfasdfgadfh
id: 3 - Name: John Email: abc@email.com
id: 4 - Name: John Email: abce@email.com
id: 7 - Name: John Email: 1234@5678
id: 19 - Name: demoing Email: with@ajax
id: 21 - Name: asd Email: asf
id: 22 - Name: asd Email: asf
id: 67 - Name: admin Email: email
id: 68 - Name: admin Email: email
id: 69 - Name: admin Email: "version()
id: 70 - Name: admin Email: (select version())
id: 73 - Name: fgfhfhfh Email: sgssgs


SELECT id, email FROM Sample_Data WHERE username='Mary'
id: 5 - Name: Email: blah@email.com
id: 8 - Name: Email: yeet


SELECT Sample1.user_name, Sample1.GPA, Sample1.fav_class, ClassData.class_desc FROM Sample1 LEFT JOIN ClassData ON Sample1.fav_class=ClassData.class_name ORDER BY Sample1.user_name
NameGPAFavorite ClassClass Description
Bill 4.2 Not Dying in DnD 101 Something every DM wishes their players understood
George 4 Research
James 2.75 Networking 2
Joe 1.75 Space 101 A short introduction to the topic of human space travel
Keri 4 Space 101 A short introduction to the topic of human space travel
Robert 3.3333333333333335 Non Terminating Equations A perilous exploration of infinite loops
Ryan 3.5 History of MURICA A class covering the history of the United States through meme culture
Ryan 3.97 Elite Programming 444 A course designed to teach the most elite hacking skills
Tim 1.0001 Dining hall snack attack
Tim2 3.12 Programming is FUN~!
WizardHarry 3.14159265359 Defense against Snape
YayCode 1337 Hacking 101