Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL Chapter 6

memorize.ai (lvl 286)

(0)

23 cards

()

Section 1

Preview this deck

AND and OR

Front

1 / 23

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (23)

Section 1

(23 cards)

AND and OR

Front

What are examples of compound conditions?

Back

Numeric Value

Front

How must you specify for the AVG and SUM Functions?

Back

Group By

Front

What groups the rows of a result set based on one or more columns or expressions?

Back

COUNT(*)

Front

What ignores null values?

Back

Where and Select

Front

What clauses uses grouping and aggregates, MySQL applies the search condition before it groups the rows and calculates the aggregates?

Back

Query that counts the number of invoices by vendor?

Front

Select vendor_id, COUNT(*) AS invoices_qty From invoices Group By vendor_14

Back

Scolar Functions

Front

What operates on a single value and returns a single value?

Back

Having clause

Front

What clause can only refer to a column included in the select clause?

Back

Distinct Syntax

Front

Select Count(Distinct vendor)id) As number-of_vendors?

Back

Aggregate Function

Front

What operates on a series of values and return a single summary value?

Back

Select, Group By

Front

When this clause can include the columns used for grouping, aggregate functions, and expressions that result in a constant value?

Back

Count(*) syntax

Front

Count(*) As number_of_invoices.

Back

Having and Select

Front

What clauses uses grouping and aggregates, MySQL applies the search condition after it groups the rows and calculates the aggregates?

Back

Summary query that calculates the number of invoices and the average invoice amount for the vendors in each state and city.

Front

Select vendor_state, vendor_city COUNT(*) as invoice qty, Round(avg(invoice_total),2) as invoice_avg From invoices Join vendors On invoices.vendor_id = vendors.vendor_id GROUP BY vendor_state, vendor_city

Back

With RollUp and Groupby

Front

What is a operator in which clause to add summary rows to the final result set?

Back

Distinct

Front

How to count only the rows with unique values in a specified column?

Back

Column Function

Front

What aggregate functions typically operate on the values in columns?

Back

Where clause

Front

What clause can refer to any column in the base tables?

Back

Count(*) clause

Front

How do you count all the selected rows?

Back

WHERE

Front

What clause can contain aggregate functions?

Back

With Rollup operator

Front

What operator adds a summary row for each group specified in the Group by clause.

Back

Having

Front

What specifies a search condition for a group or an aggregate?:

Back

HAVING

Front

What clause can't contain aggregate functions?

Back