怎么用select语言建立，麻烦了麻烦了

1.list full details of all books with book title displayed in ascending order。 列出所有书的详细信息，书名按升序显示。

2.list full details of all book subjects. 列出所有书籍主题的详细信息。

3.list publisher name who publish fiction books. 列出出版小说的出版商名称。

select * from BOOKS a order by a.title asc;
select * from SUBJECTS;
select b.Name from BOOKS a,PUBLISHERS b where a.PubID=b.PubID and a.Fiction NOT NULL;

有表结构吗