FROMは、データが入ったテーブルを指します。

 

SELECT bookid AS "id", title
FROM books
WHERE author='織田 信長';

 

SELECT bookid AS “id”,title

FROM books

WHERE autor=”織田 信長”