Shared Flashcard Set

Details

Chapter 5 code
N/A
22
Computer Science
Undergraduate 2
02/07/2013

Additional Computer Science Flashcards

 


 

Cards

Term
A summary query that counts the number of invoices by vendor
Definition
[image]
Term
A summary query that includes a final summary row
Definition
[image]
Term
A summary query that works on non-numeric columns
Definition
[image]
Term
A summary query that counts unpaid invoices and calculates the total due
Definition
[image]
Term
A summary query that calculates the average invoice amount by vendor
Definition
[image]
Term
A summary query that includes a summary row for each set of groups
Definition
[image]
Term
A summary query with two groups
Definition
[image]
Term
A summary query that includes a summary row for each grouping level
Definition
[image]
Term
A summary query that uses the MIN and MAX functions
Definition
[image]
Term
A summary query that uses the COUNT, AVG, and SUM functions
Definition
[image]
Term
A summary query that calculates the number of invoices and the average invoice amount for the vendor
Definition
[image]
Term
A summary query with a search condition in the WHERE clause
Definition
[image]
Term
A summary query that uses the DISTINCT keyword
Definition
[image]
Term
A summary query with a composite grouping
Definition
[image]
Term
A query that calculates a cumulative total and moving average
Definition
[image]
Term
A summary query with a search condition in the HAVING clause
Definition
[image]
Term
A summary query that limits the groups to those with two or more invoices
Definition
[image]
Term
A query that groups the summary data by date
Definition
[image]
Term
A summary query with a compound condition in the WHERE clause
Definition
[image]
Term
A summary query with a compound condition in the HAVING clause
Definition
[image]
Term
A query that calculates a cumulative total and moving average and grouped by TermsID
Definition
[image]
Supporting users have an ad free experience!