Acct Information Systems

Final

SELECT

Indicates the attributes you wish to view

FROM

Indicates which tables contains the attributes

WHERE

Used with conditional operators to filter records that meet conditions

ORDER BY

Sort records in a query output by something else

ASC

Used by ORDER BY to sort in ascending order

DESC

Used by ORDER BY to sort in descending order

GROUP BY

Breaks down an aggregated attribute by another attribute

HAVING

Filter aggregated attributes using conditional operators

Choose the correct order for the query

SELECT, FROM, ORDER BY

Choose the correct order from the query (aggregated attributes)

SELECT, FROM, GROUP BY, HAVING

Select the correct order from the join

SELECT, FROM, ON, GROUP BY, ORDER BY

1st Order of Operations

SELECT

2nd Order of Operations

FROM

3rd Order of Operations

JOIN

4th Order of Operations

ON

5th Order of Operations

WHERE

6th Order of Operations

GROUP BY

7th Order of Operations

HAVING

8th Order of Operations

ORDER BY

SELECT

attribute 1, attribute 2, etc.

FROM

Table1 JOIN TYPE Table2

ON

Table1.attribute = Table2.attribute

HAVING

aggregate(attribute) conditional operator number

ORDER BY

attribute name ASC/DESC