(NULL) , , , . , ANSI . .
, , . : , 10 . , , , , .
.
, . , ORDER BY . , .
. , , , ORDER BY.
, , , , , . 8.
SQL
1. , 12% . , , , .
2. , . :
For the city (city), the highest rating is: (rating).
3. , . (rating) .
4. , .
(. A .)
,
, , . , , . , , . , , , .
|
|
SQL , .
, . 1, , . , , .
, , FROM , . , , . , , WHERE .
, . :
Salespeople.snum
Salespeople.city
Orders.odate
, , , SQL , , . , , . . , city.
(), Salespeople.city Customers.city, SQL .
, , , . . , ( 8.1):
SELECT Customers.cname, Salespeople.sname, Salespeople.city
FROM Salespeople, Customers
WHERE Salespeople.city = Customers.city;
=============== SQL Execution Log ============
| SELECT Customers.cname, Salespeople.sname, |
| Salespeople.city |
| FROM Salespeople, Customers |
| WHERE Salespeople.city = Customers.city |
| ============================================= |
| cname cname city |
| ------- -------- ---- |
| Hoffman Peel London |
| Clemens Peel London |
| Hoffman Motika London |
| Clemens Motika London |
| Liu Serres San Jose |
| Cisneros Serres San Jose |
===============================================
8.1. .
city , , . , , . , , , , , , .
SQL , , . , Peel , .
|
|
, city London, Peel . ( ).