Question

BOOK 112 8547 Book_id Book_Name Author Number_of_Pages Publication Year Sales Figures The Little Antoine De 1254 2019 150.000.000 Prince Saint-Exupery Of Mice and John 126 2019 250.000 Men Steinbeck 9965 Od İskender Pala 361 2017 600.000 Think of a 5214 John Verdon 480 550.000 Number Cengiz 1020 White Ship 2001 475.000 Aytmatov 2545 See Me Azra Koehn 592 2020 142.000 The Da Vinci 9651 Dan Brown 495 1999 1.120.000 Code Write SQL Query to find the Book of which name has more than six characters and amount of publication year is known, and display id of book

Answer 1

Write SQL Query to find the Book of which name has more than six characters and amount of publication year is know,

and display id of book

SQL QUERY:

SELECT Book_id

FROM BOOK

WHERE LENGTH(Book_Name) > 6 AND Publication_Year IS NOT NULL;