Don't write the SQL itself just the ANSWER!!if Taylor has cancelled her orders on the book titled Cannery Row how many is the total stockYour answerif Olivia has received her orders what is the remaining stock of Norse mythologyYour answerWhich city has the least ordered countYour answerhow many stock quantities of the namesake book does Jackson need to complete his orderYour answerWhat book title has the most ordered status?Your answerHow many times did Jackson Carter order A Heartbreaking Work of Staggering GeniusYour answerWhat book title has the most pending statusYour answerHow many times did Elijah Turner pend her order entitle the circleYour answerHow many times did Samuel pend her order entitle white noiseYour answerHow many times did Lucas Jenkins order the book entitled Just Kids

Directions: Write X when the syntax is CORRECT and Z whenthe syntax is INCORRECT. NO ERASURES!DB NAME: books_db   Table Name: books_tblAssume all column names are correct3. SELECT author_lname FROM books_tbl ORDER author_lname;Your answer7. SELECT title, released_year FROM books_tbl ORDER BY released_year DESC LIMIT 14; Your answer8. SELECT author_lname, title FROM books_tbl ORDER BY 2; Your answer5. SELECT author_lname FROM books_tbl ORDER BY author_lname BESC; Your answer10. SELECT title FROM books_tbl WHRE  title LIKE “the”;Your answer1. SELECT DISTINCTS CONCAT(author_fname,” “, author_lname) FROM books_tbl;Your answer6. SELECT title FROM books_tbl LIMIT 10;Your answer11. SELECT title, released_year FROM books_tbl WHERE released_year <= 2000;Your answer4. SELECT title FROM books ORDER BY title;Your answer15. SELECT title, released_year FROM books_tbl WHERE released_year NOT BETWEEN 2004 AND 2015;Your answer12. SELECT -10 < -9;Your answer2. SELECT DISTINCT author_fname, author_lname FROM books;Your answer9. SELECT title, stock_quantity FROM books_db;Your answer14. SELECT -10 > -20 && 0 <= 0;Your answer13. SELECT title, author_lname, released_year FROM books_tbl WHERE author_lname=”Eggers” AND released_year > 2010;

Choose the best answer to complete each sentence.Question 14. It is necessary .................... for that book.A.lookingB.lookC.to look Question 15. The stockbroker denied _____ of the secret business deal.A. having been informedB.having informedC.to have been informedD.to have informedQuestion 16. We are very surprised to .................... Ian at the party.A.seenB.seeingC.see Question 17. Are you sure you told me? I don't recall _____ about it.A. having toldB.having been toldC.to have been toldD.to have toldQuestion 18. It's not easy........... a foreign language like a native speaker.A.to speakingB.to speakC.speaking

6.Question 6Which query will return a list of all corn farms that have made more than $4 million, ordered by the greatest number of years in business to the fewest number of years in business?1 point

Which call number (book) would be first on the shelf? A. QH 541 .F5 2017 B. QH 541 .C3 2014 C. QH 541 .C25 2014

Question 6Which query will return a list of all corn farms that have made more than $4 million, ordered by the greatest number of years in business to the fewest number of years in business?