1. Look at the marks first, then work out how long it is worth spending on each section:
You do not lose marks for wrong answers, so attempt every question.
SELECT aggregate(x.field) AS alias
FROM x INNER JOIN y on x.field == y.field
WHERE x.field<val1 AND filter2 OR filter3
GROUP BY aggregate(y.field)
HAVING y.field>val2 ...
ORDER BY x.col1 ASC, y.col2 DESC
If you see CREATE, INSERT, DELETE or UPADTE, don't panic - think back to past assignments.
4. Block cipher shifts
5. Expect the unexpected
ALTER TABLE Students ADD FOREIGN KEY (StudentID) REFERENCES Medical(StudentID) ON DELETE RESTRICT ON UPDATE CASCADE;
Deal with the unexpected by being strategic & problem solving. Content may appear from year 11, past assignments or unfamiliar sources. You are a Digital Solutions student, so find a solution.