1. Query all records in the Book table.

Choose from books *

2. Query the library card number, name and gender of all records in the "Readers" table.

Select the library card number, name and gender from the reader.

3. Inquire about the book information whose publisher is "Higher Education Press" and whose first author is "Zhang San".

SELECT * FROM Books WHERE Press =' Higher Education Press', the first author =' Zhang San'

4. Check the book number (assuming that the book number of each book is different).

Select a count from the book.

5. Inquire the reader's name and unit of the book number "TP 1 100 1".

Select a reader. Reader's name, reader. Where can I borrow a reader from the unit? Library card number = borrowing. Library card number and borrowing. Book number =' TP 1 100 1'

6. Query the number of male readers and female readers (using SQL statements).

Select gender from the reader group by gender, COUNT(*).

7. Query the name, gender and professional title of the reader who borrowed the book (nested query is required).

Select the library card number where the reader's name, gender and professional title are located (select the library card number from borrowing).

8. Insert a new record in the "Books" table, the book number is "TP111",the title is "Database Principles and Applications", and the publishing house is "Tsinghua University Publishing House".

Values inserted into books (ISBN, ISBN, publishing house) ('TP111','Database Principles and Applications',' Tsinghua University Publishing House').

9. Change the gender of the reader named "Li Si" to "female".

Update reader's setting gender =' female' where name =' Li Si'

10. Delete the borrowing information before 20 10 1.

Delete the borrowing date from the borrowing place