Evidence
Create a document to store screenshots of your work eg a Google Doc or a Word Doc.
Task 1
Write some SQL that will query the above table, Students. It will show all fields in every record in ascending order of Age.
Paste a screenshot of your SQL and the result of the query into your evidence document. Label it Task 1.
Task 2
Write some SQL that will query the above table, Students. It will show the First name, Last name and Age where the student is older han 19.
Paste a screenshot of your SQL and the result of the query into your evidence document. Label it Task 2.
Task 3
Write some SQL that will query the above table, Students. It will show the ID, Location and Favourite Food where the student likes Sky Sports or Sports Network in descending order of Location.
Paste a screenshot of your SQL and the result of the query into your evidence document. Label it Task 3.
Task 4
Write some SQL that will query the above table, Students. It will show a count of every student who is from USA and likes Pizza.
Paste a screenshot of your SQL and the result of the query into your evidence document. Label it Task 4.