Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

9 cards

()

Section 1

Preview this deck

JOIN

Front

1 / 9

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 (9)

Section 1

(9 cards)

JOIN

Front

Orders ON customer.customerID=orders.orderID

Back

AS

Front

"Sales Total"

Back

FROM

Front

Orderlines, Orders, Customers

Back

HAVING

Front

SUM (Unit Price * Quantity) > 50,000

Back

ORDER BY

Front

Desc

Back

JOIN

Front

Orderlines ON orders.orderID=orderlines.orderID

Back

SELECT

Front

_, __, SUM (Unit Price * Quantity)

Back

GROUP BY

Front

customerID, customername

Back

WHERE

Front

to______char (orderdate, 'YYYY') = "2016"

Back

SQL

Preview this deck

JOIN

0.0

Cards (9)

JOIN

Orders ON customer.customerID=orders.orderID

AS

"Sales Total"

FROM

Orderlines, Orders, Customers

HAVING

SUM (Unit Price * Quantity) > 50,000

ORDER BY

Desc

JOIN

Orderlines ON orders.orderID=orderlines.orderID

SELECT

_________, __________, SUM (Unit Price * Quantity)

GROUP BY

customerID, customername

WHERE

to______char (orderdate, 'YYYY') = "2016"

_, __, SUM (Unit Price * Quantity)