Names 4 111512 joiningtables

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: extrac)ons
 SELECT Name,Addr FROM Customers; Name Address 1 Smith, J 101 Elm 2 Smith, D 101 Elm 3 Brown, D 17 Spruce 3
 11/15/12
 Warmup
 Warmup
 •  All
of
the
aZributes
in
the
Registra)on
table
 for
accounts
belonging
to
Customer
3.

 •  Account
numbers
for
accounts
that
don’t
 meet
minimum
$100
balance
in
City
branch.

 SELECT * FROM Registration WHERE CID = 3; row_names CID AcctNo 1  4 3 203 2  5 3 301 36 3 302 SELECT AcctNo FROM Accounts WHERE Branch = 'City' AND Balance < 100; AcctNo 1 201 •  The
total
balance
for
all
accounts
belonging
to
 a
branch.

 •  The
total
overdrawn
amount
at
a
branch,
for
 those
branches
which
...
View Full Document

This note was uploaded on 05/08/2013 for the course STAT 133 taught by Professor Staff during the Fall '08 term at University of California, Berkeley.

Ask a homework question - tutors are online