Aggregate functions correct answers calculate sums, averages, counts, maximum values, and minimum values
AND correct answers connects simple conditions, all the simple conditions must be true for the compound condition to be true
AND condition correct answers when a WHERE caluse uses the AND ...
GBUS 3301 FINAL || WITH A+ GUARANTEED
SOLUTIONS.
Aggregate functions correct answers calculate sums, averages, counts, maximum values, and
minimum values
AND correct answers connects simple conditions, all the simple conditions must be true for the
compound condition to be true
AND condition correct answers when a WHERE caluse uses the AND operator to connect
simple conditions it also is called an AND condition
AS correct answers you also can assign a name or alias, to a computed column by following the
computation with the word AS and the desired name
AVG correct answers calculates the average value in a numeric range, MAX calculates the
maximum value in a numeric range, and MIN calculates the minimum value in a numeric range.
BETWEEN correct answers lets you specify a range of values in a condition.
compound condition correct answers You form a compound condition by connecting two or
more simple conditions with the AND, OR, and NOT operators.
computed column correct answers does not exist in the database but can be computed using data
in the existing columns.
COUNT correct answers counts the number of rows in a table.
DESC correct answers To sort in descending order, you follow the name of the sort key
DISTINCT correct answers useful when used in conjunction with the COUNT function because
it eliminates duplicate values in the query results.
GROUP BY clause correct answers lets you group data on a particular column, such as REP_ID,
and then calculate statistics
grouping correct answers creates groups of rows that share some common characteristic.
HAVING clause correct answers limits the groups that are included in the results.
IN clause correct answers which consists of the IN operator followed by a collection of values,
provides a concise way of phrasing certain conditions
is null... its not null correct answers is null = is null not null = is not null
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 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 £8.27. You're not tied to anything after your purchase.
