Higher DDD - Using queries in queries

Multiple Select

Select all statements that correctly describe aggregate functions.

• They return a value when run on a row or set of rows.

• They can only be used in Microsoft Excel, not in databases.

• They perform calculations such as sum, average, min, and max.

• They are used to filter rows based on a condition.

Multiple Choice

Which aggregate function would you use to find the smallest value in a column?

• SUM()

• MAX()

• MIN()

• AVG()

Multiple Choice

Which of the following is NOT a common aggregate function used in databases?

• AVG()

• COUNT()

• MIN()

• FIND()

Open Ended

How confident do you feel about incorporating data from a query containing an aggregate function into another query after this lesson?

Multiple Choice

What is one way you can use data from a database query in another query?

• By using subqueries

• By creating a new table

• By exporting data to a spreadsheet

• By deleting the original query