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 free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…