Consider the table BOOKS with the following sample records: Table: BOOKSBOOKID…
PYQ KVS TGT/PGT 2026
Consider the table BOOKS with the following sample records:
Table: BOOKS
BOOKID | BookTitle | Author | Price | Edition | PubID |
|---|---|---|---|---|---|
2026103 | Data Science | J P Singh | 350 | 2025 | P12 |
2026112 | Lets Python | Harpreet Kaur | 400 | 2026 | P12 |
2025125 | RDBMS | Gems Gomez | 300 | 2026 | P09 |
(Note: The table contains additional records.)
Write MySQL queries to perform the following operations:
(A) Display complete details of books published in the year 2025 or later.
(B) Display the average price of all books.
(C) Display the total number of books published in each year.
(D) Display the details of all books whose title contains the word “Python” anywhere in the BookTitle.
Attempted by 24 students.
Sign up free to check your answer
Sign up freeLoading lesson…

