Consider the following tables BOOKS and PUBLISHERS with the following sample…

PYQ KVS TGT/PGT 2026

Consider the following tables BOOKS and PUBLISHERS 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

Table: PUBLISHERS

PubID

PubName

City

EmailID

P09

Rupa Prakashan

Kolkata

rupa@bharat.in

P10

Modern Books

Noida

modernbooks@gmail.com

P12

IA Publishers

Delhi

iap@yahoo.co.in

(Note: Both the table contains additional records.)

Write appropriate MySQL queries to perform the following tasks:

  • (A) Display the title of each book along with the name of its publisher.

  • (B) Display the average price of books published by publishers located in Delhi.

  • (C) Display the total number of books published from each city.

  • (D) Display the book title and corresponding publisher name for books whose title contains the word “RDBMS” anywhere in the BookTitle.

Attempted by 13 students.

Sign up free to check your answer

Sign up free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…