the systematic process of transforming a software idea into functional software
the process of creating new software solutions
count, min, max, sum, avg used with select to return mathematical summaries on columns