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 freeLoading lesson…

