The SELECT StatementSelecting columns from a tableOrdering query resultsRestricting query resultsNull ValuesUsing the NVL functionTable JoinsInner and outer joinsSummary QueriesUsing aggregate functionsUsing GROUP BYRestricting summarized resultsUsing ALL and DISTINCTUnions