|
SQL>
SQL>
SQL> CREATE TABLE employees (
2 au_id CHAR(3) NOT NULL,
3 au_fname VARCHAR(15) NOT NULL,
4 au_lname VARCHAR(15) NOT NULL,
5 phone VARCHAR(12) NULL ,
6 address VARCHAR(20) NULL ,
7 city VARCHAR(15) NULL ,
8 state CHAR(2) NULL ,
9 zip CHAR(5) NULL
10 );
Table created.
SQL>
SQL> INSERT INTO employees VALUES('A01','S','B','111-111-1111','75 St','Boston','NY','11111');
1 row created.
SQL> INSERT INTO employees VALUES('A02','W','H','222-222-2222','2922 Rd','Boston','CO','22222');
1 row created.
SQL> INSERT INTO employees VALUES('A03','H','H','333-333-3333','3800 Ave, #14F','San Francisco','CA','33333');
1 row created.
SQL> INSERT INTO employees VALUES('A04','K','H','444-444-4444','3800 Ave, #14F','San Francisco','CA','44444');
1 row created.
SQL> INSERT INTO employees VALUES('A05','C','K','555-555-5555','114 St','New York','NY','55555');
1 row created.
SQL> INSERT INTO employees VALUES('A06',' ','K','666-666-666','390 Mall','Palo Alto','CA','66666');
1 row created.
SQL> INSERT INTO employees VALUES('A07','P','O','777-777-7777','1442 St','Sarasota','FL','77777');
1 row created.
SQL>
SQL>
SQL>
SQL> SELECT au_fname, au_lname, city, state
2 FROM employees
3 ORDER BY state ASC,
4 city DESC;
AU_FNAME AU_LNAME CITY ST
--------------- --------------- --------------- --
K H San Francisco CA
H H San Francisco CA
K Palo Alto CA
W H Boston CO
P O Sarasota FL
C K New York NY
S B Boston NY
7 rows selected.
SQL>
SQL> drop table employees;
Table dropped.
|