Description: (1) check the state of the table (state) authors in where the ' CA' all records and information au_lname is beginning M. (2) check the state of the table (state) authors in where the ' KS' , or the address where the record is empty author name, last name, address, and your state (state) information. Information (3) the query of the table authors in city (city) belonging to ' oakland' or ' berkeley' or ' covelo' record number of authors, author' s last name and the city, according to the author numbered in ascending order. (4) queries of table authors in city (city) does not belong to ' oakland' , ' berkeley' and ' covelo' all record information.
To Search:
File list (Check if you may need any files):
lab\lab7.sql
...\实验8参考答案.sql
lab
Download