Aggregates and JOINs

We use combinations of SQL commands, clauses, and functions to obtain information from a database. Typically, tables are combined to create temporary relations, and we apply select statements with clauses, constraints, and functions to obtain the desired information from a database. Watch this example of a query involving select, inner join, and aggregate.