aggregate functions correct answers used to calculate sums, averages, counts, maximum values, and minimum values.
AND correct answers operator connects simple conditions, all the simple conditions must be true for the compound condition to be true.
AND condition correct answers When a WHERE c...
GBUS 3301 final || with Complete Solutions.
aggregate functions correct answers used to calculate sums, averages, counts, maximum values,
and minimum values.
AND correct answers operator connects simple conditions, all the simple conditions must be true
for the compound condition to be true.
AND condition correct answers When a WHERE clause uses the AND operator to connect
simple conditions, it also is called an
AS correct answers You also can assign a name, or alias, to a computed column by following the
computation with the word __ and the desired name.
AVG correct answers calculates the average value in a numeric range
BETWEEN correct answers operator lets you specify a range of values in a condition.
compound condition correct answers formed by connecting two or more simple conditions with
the AND, OR, and NOT operators.
Compound columns correct answers perform computations using SQL queries. Does not exist in
the database but can be computed using data in the existing columns.
COUNT correct answers function counts the number of rows in a table
DESC correct answers used to sort in descending order. follows an ORDER BY
DISTINCT correct answers operator that eliminates duplicate values in the query results.
COUNT correct answers what function to use distinct with
GROUP BY correct answers clause lets you group data on a particular column, such as REP_ID,
and then calculate statistics, when desired
Grouping correct answers creates groups of rows that share some common characteristic.
HAVING correct answers clause limits the groups that are included in the results.
IN correct answers clause, which consists of the __ operator followed by a collection of values,
provides a concise way of phrasing certain conditions
key (sort key) correct answers The column on which to sort data.
LIKE correct answers operator uses one or more wildcard characters to test for a pattern match.
, major sort key (primary sort key) correct answers When you need to sort data on two columns,
the more important column
MAX correct answers calculates the maximum value in a numeric range
MIN correct answers calculates the minimum value in a numeric range.
minor sort key (secondary sort key) correct answers When you need to sort data on two columns,
the less important column
the more important column (major sort key) if first, then the less important column is next
(minor sort key) correct answers what order do you put columns (regarding minor and major sort
key)
NOT correct answers Preceding a condition by the ___ operator reverses the truth of the original
condition.
NOT condition correct answers When a WHERE clause uses the NOT operator to connect
simple conditions
OR correct answers When the ___ operator connects the simple conditions, the compound
condition will be true whenever any one of the simple conditions is true.
OR condition. correct answers When a WHERE clause uses the OR operator to connect simple
conditions, it also is called an
ORDER BY correct answers clause used to list data in a specific order
query correct answers a question represented in a way that the DBMS can understand.
Simple condition correct answers The condition preceding the WHERE clause. has the form:
column name, comparison operator, and then either another column name or a value.
sort key correct answers The column on which to sort data
subquery correct answers The inner query is called a
alias correct answers An alternate name, that you can use in the rest of the statement.
ALL correct answers When you precede the subquery by the ___ operator, the condition is true
only if it satisfies all values produced by the subquery.
ANY correct answers When you precede the subquery by the ___ operator, the condition is true
if it satisfies any value (one or more) produced by the subquery.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.79. You're not tied to anything after your purchase.
