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;

Write a query to display the book_code, book_title of the books which are issued on the date "01-04-2012". Display the records sorted in ascending order based on book_code.Note:1. Display only the book_code, book_title of the books which are issued on the date "01-04-2012" from lms_book_issue and lms_book_details table.2. Use Joins. Tables involved are lms_book_issue and lms_book_details.3. Order by is mandatory.Sample Output:

Consider the following schema for institute library: Student (Roll No, Name, Father_ Name, Branch) Book (ISBN, Title, Author, Publisher) Issue (Roll No, ISBN, Date-of –Issue) Write the following queries in SQL and relational algebra: List roll number and name of all students of the branch ‘CSE’. Find the name of student who has issued a book published by ‘ABC’ publisher. List title of all books and their authors issued to a student ‘RAM’. List title of all books issued on or before December 1, 2020.List all books published by publisher ‘ABC’.

Problem StatementGiven a library management system with tables for publishers, library branches, books, book authors, book copies, and book lending. Write a query to retrieve details about books, including the book ID, title, publisher name, publication year, author name, number of copies, branch name, and branch address.The following table is already created, and the records are inserted into the table.Table Details:The sample records are given below. Input format :The input records are already prepopulated, as given in the problem statement.Output format :The output is a detailed dataset that includes the following information for each book as shown below:Book_id Title Publisher_Name Pub_Year Author_Name No_of_Copies Branch_Name Branch_Address1 Introduction to SQL Tech Publications 2020 John Smith 10 Main Library 123 Library St2 Python Programming Code Books 2019 David Miller 15 Downtown Branch 456 Downtown St3 Data Science Handbook Data Insights 2021 Anna White 20 Suburb Branch 789 Suburb St4 Algorithms Unlocked Algorithm House 2018 Chris Brown 8 Main Library 123 Library St5 Database Management Systems Tech Publications 2017 Emma Wilson 12 Downtown Branch 456 Downtown StRefer to the sample output for the column headers.Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.

Directions:  Write TRUE if the statement is true and FALSEif the statement is not true. USECAPITAL LETTERS!______6. SELECT title, author_lname, released_year FROM books_tbl WHERE author_lname=”Eggers” AND released_year > 2010; Your answer______3. The normalization process in database design aims to eliminate data redundancy and dependency. Your answer______7. Sharding is a technique used to horizontally partition a database, distributing different portions of a table across multiple servers. Your answer______4. SELECT -10 < -9;Your answer______5. In-memory databases store and manage data in the computer's main memory (RAM) rather than on disk for faster access. Your answer______10. SELECT title, released_year FROM books_tbl WHERE released_year NOT BETWEEN 2004 AND 2015;Your answer______1. In a graph database, relationships between data entities are as important as the entities themselves. Your answer______2. SELECT title, released_year FROM books_tbl WHERE released_year <= 2000;Your answer______8. SELECT -10 > -20 && 0 <= 0;Your answer______9. In a relational database, a foreign key establishes a link between two databases. Your answerBackSubmitClear form

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