TK Study
HomeLearn step by stepMemoriseKey termsFlashcardsNotesMaster answersPast questionsMultiple choiceMock examPractice & marker

Software Engineering › Key terms › Y12 Programming for the Web › SQL alias (AS)

SQL alias (AS)

Code pattern Check Y12 Programming for the Web

Definition

Gives a table or column a temporary name to make queries shorter and clearer: SELECT s.name AS student FROM Student AS s.

Example: FROM Student AS s JOIN Class AS c

Check this one: Not found word-for-word in the supplied syllabus, specifications, marking guidelines or notes; the definition is standard computing knowledge, so check it against your class notes.

Where it is used in the test

Syllabus area: Y12 Programming for the Web.

Question types it can appear in

Where it has appeared in the paper

Programming for the Web (Part C). Part letters follow each paper’s own layout.

Related past questions

These are the questions the flashcard set links to this term. Open each one and compare your answer with its marking criteria.

Other questions that mention it

Study links

How to use it in an answer

A model sentence

General advice, built from the definition and example above

Code pattern: “Gives a table or column a temporary name to make queries shorter and clearer: SELECT s.name AS student FROM Student AS s.” Then apply it: FROM Student AS s JOIN Class AS c

In a short answer, give the definition in your own words first, then tie it to the situation in the question. Do not copy the example above unless it fits the scenario.

Technique for the question types

Worked answers from the marking guidelines

Familiarisation Q12b (3 marks): SQL (joins, AS) (3 marks): criteria and sample answer

Criteria

3: Correct SQL query. 2: Substantially correct query with at least TWO of: renaming the columns; selecting the three tables; joining the tables. 1: Some understanding of renaming the columns or joining the tables.

Sample answer

SELECT Customers.CustName as 'Customer', Products.ProductName as 'Product', Orders.OrderQuantity as 'Quantity' FROM Products, Customers, Orders WHERE Orders.ProductID = Products.ProductID AND Orders.CustID = Customers.CustID ORDER BY Orders.OrderID ASC

Open the question page

Common mistakes

Marker feedback on other questions of the same type (code and diagram feedback often applies across questions)
  • Check the sources: Not found word-for-word in the supplied syllabus, specifications, marking guidelines or notes; the definition is standard computing knowledge, so check it against your class notes.
  • SQL questions (2025 HSC exam Q21): query must run; quotation marks around data being searched; use OR/AND in WHERE; correct GROUP BY and ORDER BY fields.
General advice
  • Use the term exactly as the syllabus words it, then link it to the scenario in the question; the 2025 feedback repeatedly rewards using the stimulus.
  • Answer the command word: outline gives main points only, explain gives a reason or cause, discuss gives both sides.

Same group in the syllabus: Shell commands (mkdir, cd, touch, cp, rm, cat, grep) · SQL SELECT · SQL WHERE · SQL ORDER BY · SQL GROUP BY · SQL aggregate functions (COUNT, SUM, AVG) · SQL JOIN · SQL constraints · Primary key and foreign key · Object-relational mapping (ORM) · Service worker · Web app manifest · CRUD

A to Z
← SQL aggregate functions (COUNT, SUM, AVG)In Y12 Programming for the WebSQL and non-SQL databases →