Nutzung interaktiver Medien

Select
SUM() AS Summe
COUNT() AS
AVG() AS
MAX() AS
MIN() AS

From
alle relevante Bereiche

Where
AND....Verbingung von jedem Feld
PLZ>"4000" AND PLZ< "5000"
PLZ LIKE "4%"
Nachname="GUT"
Nachname LIKE"M%" oder LIKE"%N" oder LIKE"%%"
PLZ.Ort="Wien"

Group by
Having nur für SUM,COUNT etc.
Having Summe>"20000"
Order by .....ASC/DESC