{"id":2224,"date":"2025-11-11T15:18:51","date_gmt":"2025-11-11T15:18:51","guid":{"rendered":"https:\/\/itxperts.co.in\/blog\/?p=2224"},"modified":"2025-11-11T15:19:20","modified_gmt":"2025-11-11T15:19:20","slug":"mysql-practice-questions-cbse-class-12-ip","status":"publish","type":"post","link":"https:\/\/itxperts.co.in\/blog\/mysql-practice-questions-cbse-class-12-ip\/","title":{"rendered":"MySQL Practice Questions for CBSE Class 12 IP Students"},"content":{"rendered":"\n

Master MySQL for your CBSE Class 12 Informatics Practices exam with these comprehensive practice questions, sample tables, and detailed solutions.<\/em><\/p>\n\n\n\n

\n\n\n\n

Introduction<\/h2>\n\n\n\n

Are you preparing for your CBSE Class 12 Informatics Practices (IP) exam and feeling overwhelmed with MySQL queries? Don’t worry! This complete guide will help you master MySQL concepts including Joins, Aggregate Functions, String Functions, Date Functions<\/strong>, and much more.<\/p>\n\n\n\n

At Itxperts<\/strong>, we understand the challenges students face while learning database concepts. That’s why we’ve created this comprehensive practice set with real-world examples and detailed explanations.<\/p>\n\n\n\n

\n\n\n\n

Sample Database Tables<\/h2>\n\n\n\n

Let’s start by creating three interconnected tables that simulate a school management system. These tables will help you practice various SQL queries and joins.<\/p>\n\n\n\n

Table 1: STUDENTS<\/h3>\n\n\n\n
CREATE TABLE STUDENTS (\n    StudentID INT PRIMARY KEY,\n    Name VARCHAR(50),\n    Class VARCHAR(5),\n    Section CHAR(1),\n    DOB DATE,\n    City VARCHAR(30),\n    Marks INT\n);\n\nINSERT INTO STUDENTS VALUES\n(101, 'Aarav Sharma', '12', 'A', '2007-05-15', 'Delhi', 92),\n(102, 'Diya Patel', '12', 'A', '2007-08-22', 'Mumbai', 88),\n(103, 'Rohan Kumar', '12', 'B', '2007-03-10', 'Bangalore', 95),\n(104, 'Ananya Singh', '12', 'A', '2007-11-05', 'Delhi', 78),\n(105, 'Arjun Reddy', '12', 'B', '2007-07-18', 'Hyderabad', 85),\n(106, 'Priya Gupta', '12', 'C', '2007-09-30', 'Mumbai', 91),\n(107, 'Karan Mehta', '12', 'C', '2007-02-14', 'Delhi', 82),\n(108, 'Ishita Jain', '12', 'B', '2007-12-25', 'Pune', 89);\n<\/code><\/pre>\n\n\n\n
Table 2: LIBRARY<\/h3>\n\n\n\n
CREATE TABLE LIBRARY (\n    BookID INT PRIMARY KEY,\n    BookName VARCHAR(60),\n    Author VARCHAR(40),\n    Publisher VARCHAR(40),\n    Price DECIMAL(7,2),\n    Quantity INT,\n    StudentID INT,\n    IssueDate DATE,\n    FOREIGN KEY (StudentID) REFERENCES STUDENTS(StudentID)\n);\n\nINSERT INTO LIBRARY VALUES\n(201, 'Python Programming', 'John Smith', 'Tech Publications', 450.00, 5, 101, '2024-10-15'),\n(202, 'Data Structures', 'Robert Sedgewick', 'Pearson', 650.00, 3, 103, '2024-10-20'),\n(203, 'Database Management', 'Raghu Ramakrishnan', 'McGraw Hill', 550.00, 4, 102, '2024-10-18'),\n(204, 'Web Development', 'Jennifer Robbins', 'O Reilly', 720.00, 2, 105, '2024-11-01'),\n(205, 'Artificial Intelligence', 'Stuart Russell', 'Prentice Hall', 890.00, 3, 103, '2024-10-25'),\n(206, 'Computer Networks', 'Andrew Tanenbaum', 'Pearson', 600.00, 4, 106, '2024-11-05'),\n(207, 'Operating Systems', 'Abraham Silberschatz', 'Wiley', 750.00, 2, NULL, NULL),\n(208, 'Machine Learning', 'Tom Mitchell', 'McGraw Hill', 820.00, 3, NULL, NULL);\n<\/code><\/pre>\n\n\n\n
Table 3: COURSES<\/h3>\n\n\n\n
CREATE TABLE COURSES (\n    CourseID INT PRIMARY KEY,\n    CourseName VARCHAR(50),\n    Duration INT,\n    Fees DECIMAL(8,2),\n    StudentID INT,\n    FOREIGN KEY (StudentID) REFERENCES STUDENTS(StudentID)\n);\n\nINSERT INTO COURSES VALUES\n(301, 'Python Programming', 6, 15000.00, 101),\n(302, 'Web Development', 8, 18000.00, 102),\n(303, 'Data Science', 10, 25000.00, 103),\n(304, 'Artificial Intelligence', 12, 30000.00, 104),\n(305, 'Machine Learning', 10, 28000.00, 105),\n(306, 'Cyber Security', 8, 20000.00, 106),\n(307, 'Mobile App Development', 6, 16000.00, 107);\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Practice Questions with Solutions<\/h2>\n\n\n\n
Section A: Basic SELECT Queries<\/h3>\n\n\n\n
Q1.<\/strong> Display all students from Delhi.<\/p>\n\n\n\n
SELECT * FROM STUDENTS WHERE City = 'Delhi';\n<\/code><\/pre>\n\n\n\n
Expected Output:<\/strong><\/p>\n\n\n\n
StudentID<\/th>Name<\/th>Class<\/th>Section<\/th>DOB<\/th>City<\/th>Marks<\/th><\/tr><\/thead>
101<\/td>Aarav Sharma<\/td>12<\/td>A<\/td>2007-05-15<\/td>Delhi<\/td>92<\/td><\/tr>
104<\/td>Ananya Singh<\/td>12<\/td>A<\/td>2007-11-05<\/td>Delhi<\/td>78<\/td><\/tr>
107<\/td>Karan Mehta<\/td>12<\/td>C<\/td>2007-02-14<\/td>Delhi<\/td>82<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
Q2.<\/strong> Display names of students who scored more than 85 marks.<\/p>\n\n\n\n
SELECT Name, Marks FROM STUDENTS WHERE Marks > 85;\n<\/code><\/pre>\n\n\n\n
Answer:<\/strong> This query uses the WHERE clause to filter records based on the condition.<\/p>\n\n\n\n
\n\n\n\n
Q3.<\/strong> Display book names with price between \u20b9500 and \u20b9700.<\/p>\n\n\n\n
SELECT BookName, Price FROM LIBRARY \nWHERE Price BETWEEN 500 AND 700;\n<\/code><\/pre>\n\n\n\n
\n
\ud83d\udca1 Itxperts Tip:<\/strong> The BETWEEN operator is inclusive, meaning it includes both boundary values (500 and 700).<\/p>\n<\/blockquote>\n\n\n\n
\n\n\n\n
Q4.<\/strong> Display student names in alphabetical order.<\/p>\n\n\n\n
SELECT Name FROM STUDENTS ORDER BY Name;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q5.<\/strong> Display unique cities from the STUDENTS table.<\/p>\n\n\n\n
SELECT DISTINCT City FROM STUDENTS;\n<\/code><\/pre>\n\n\n\n
Explanation:<\/strong> The DISTINCT keyword removes duplicate values from the result set.<\/p>\n\n\n\n
\n\n\n\n
Section B: Aggregate Functions<\/h2>\n\n\n\n
Need expert guidance? Itxperts<\/strong> offers personalized tutoring for CBSE Class 12 IP students!<\/em><\/p>\n\n\n\n
Q6.<\/strong> Count the total number of students.<\/p>\n\n\n\n
SELECT COUNT(*) AS TotalStudents FROM STUDENTS;\n<\/code><\/pre>\n\n\n\n
Output:<\/strong> 8<\/p>\n\n\n\n
\n\n\n\n
Q7.<\/strong> Find the average marks of all students.<\/p>\n\n\n\n
SELECT AVG(Marks) AS AverageMarks FROM STUDENTS;\n<\/code><\/pre>\n\n\n\n
Output:<\/strong> 87.5<\/p>\n\n\n\n
\n\n\n\n
Q8.<\/strong> Find the highest and lowest book price.<\/p>\n\n\n\n
SELECT MAX(Price) AS HighestPrice, MIN(Price) AS LowestPrice \nFROM LIBRARY;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q9.<\/strong> Calculate total fees collected from all courses.<\/p>\n\n\n\n
SELECT SUM(Fees) AS TotalFees FROM COURSES;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q10.<\/strong> Count the number of books issued to students.<\/p>\n\n\n\n
SELECT COUNT(StudentID) AS BooksIssued FROM LIBRARY \nWHERE StudentID IS NOT NULL;\n<\/code><\/pre>\n\n\n\n
Explanation:<\/strong> We use IS NOT NULL to count only issued books (excluding books in stock).<\/p>\n\n\n\n
\n\n\n\n
Section C: GROUP BY and HAVING Clause<\/h2>\n\n\n\n
Q11.<\/strong> Display city-wise count of students.<\/p>\n\n\n\n
SELECT City, COUNT(*) AS StudentCount \nFROM STUDENTS \nGROUP BY City;\n<\/code><\/pre>\n\n\n\n
Expected Output:<\/strong><\/p>\n\n\n\n
City<\/th>StudentCount<\/th><\/tr><\/thead>
Delhi<\/td>3<\/td><\/tr>
Mumbai<\/td>2<\/td><\/tr>
Bangalore<\/td>1<\/td><\/tr>
Hyderabad<\/td>1<\/td><\/tr>
Pune<\/td>1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
Q12.<\/strong> Display section-wise average marks.<\/p>\n\n\n\n
SELECT Section, AVG(Marks) AS AvgMarks \nFROM STUDENTS \nGROUP BY Section;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q13.<\/strong> Display publisher-wise total book quantity.<\/p>\n\n\n\n
SELECT Publisher, SUM(Quantity) AS TotalBooks \nFROM LIBRARY \nGROUP BY Publisher;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q14.<\/strong> Display cities having more than 1 student.<\/p>\n\n\n\n
SELECT City, COUNT(*) AS StudentCount \nFROM STUDENTS \nGROUP BY City \nHAVING COUNT(*) > 1;\n<\/code><\/pre>\n\n\n\n
\n
\ud83d\udccc Itxperts Note:<\/strong> HAVING is used with GROUP BY to filter grouped records, while WHERE filters individual records.<\/p>\n<\/blockquote>\n\n\n\n
\n\n\n\n
Q15.<\/strong> Display publishers having average price more than \u20b9600.<\/p>\n\n\n\n
SELECT Publisher, AVG(Price) AS AvgPrice \nFROM LIBRARY \nGROUP BY Publisher \nHAVING AVG(Price) > 600;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Section D: String Functions<\/h2>\n\n\n\n
Q16.<\/strong> Display student names in uppercase.<\/p>\n\n\n\n
SELECT UPPER(Name) AS NameInCaps FROM STUDENTS;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q17.<\/strong> Display the first 4 characters of book names.<\/p>\n\n\n\n
SELECT LEFT(BookName, 4) AS ShortName FROM LIBRARY;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q18.<\/strong> Display the length of each student’s name.<\/p>\n\n\n\n
SELECT Name, LENGTH(Name) AS NameLength FROM STUDENTS;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q19.<\/strong> Display book names containing the word ‘Data’.<\/p>\n\n\n\n
SELECT BookName FROM LIBRARY WHERE BookName LIKE '%Data%';\n<\/code><\/pre>\n\n\n\n
Explanation:<\/strong> The % wildcard matches any sequence of characters.<\/p>\n\n\n\n
\n\n\n\n
Q20.<\/strong> Concatenate student name with their city.<\/p>\n\n\n\n
SELECT CONCAT(Name, ' - ', City) AS StudentInfo FROM STUDENTS;\n<\/code><\/pre>\n\n\n\n
Sample Output:<\/strong> “Aarav Sharma – Delhi”<\/p>\n\n\n\n
\n\n\n\n
Section E: Date Functions<\/h2>\n\n\n\n
Struggling with date functions? Join Itxperts<\/strong> online coaching program for detailed explanations!<\/em><\/p>\n\n\n\n
Q21.<\/strong> Display the current date.<\/p>\n\n\n\n
SELECT CURDATE() AS CurrentDate;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q22.<\/strong> Display the year of birth for all students.<\/p>\n\n\n\n
SELECT Name, YEAR(DOB) AS BirthYear FROM STUDENTS;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q23.<\/strong> Display the month name when books were issued.<\/p>\n\n\n\n
SELECT BookName, MONTHNAME(IssueDate) AS IssueMonth \nFROM LIBRARY \nWHERE IssueDate IS NOT NULL;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q24.<\/strong> Calculate the age of students.<\/p>\n\n\n\n
SELECT Name, YEAR(CURDATE()) - YEAR(DOB) AS Age FROM STUDENTS;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q25.<\/strong> Display books issued in October 2024.<\/p>\n\n\n\n
SELECT BookName, IssueDate FROM LIBRARY \nWHERE MONTH(IssueDate) = 10 AND YEAR(IssueDate) = 2024;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Section F: Mathematical Functions<\/h2>\n\n\n\n
Q26.<\/strong> Display book prices rounded to the nearest integer.<\/p>\n\n\n\n
SELECT BookName, ROUND(Price) AS RoundedPrice FROM LIBRARY;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q27.<\/strong> Calculate 10% discount on course fees.<\/p>\n\n\n\n
SELECT CourseName, Fees, ROUND(Fees * 0.9, 2) AS DiscountedFees \nFROM COURSES;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q28.<\/strong> Display the square of marks (marks\u00b2).<\/p>\n\n\n\n
SELECT Name, Marks, POW(Marks, 2) AS MarksSquare FROM STUDENTS;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q29.<\/strong> Display the absolute difference between marks and 100.<\/p>\n\n\n\n
SELECT Name, Marks, ABS(100 - Marks) AS Difference FROM STUDENTS;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Q30.<\/strong> Display the square root of book prices.<\/p>\n\n\n\n
SELECT BookName, Price, ROUND(SQRT(Price), 2) AS SqrtPrice \nFROM LIBRARY;\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Section G: JOINS (Most Important for CBSE!)<\/h2>\n\n\n\n
This section is crucial for scoring well in your IP exam. Itxperts<\/strong> specializes in making complex concepts simple!<\/em><\/p>\n\n\n\n
Understanding JOINS<\/h3>\n\n\n\n
Joins are used to combine rows from two or more tables based on a related column. There are different types of joins:<\/p>\n\n\n\n
    \n
  1. INNER JOIN<\/strong> – Returns matching records from both tables<\/li>\n\n\n\n
  2. LEFT JOIN<\/strong> – Returns all records from the left table and matching records from the right<\/li>\n\n\n\n
  3. RIGHT JOIN<\/strong> – Returns all records from the right table and matching records from the left<\/li>\n<\/ol>\n\n\n\n
    \n\n\n\n
    Q31.<\/strong> Display student names with the books they have issued. (INNER JOIN)<\/p>\n\n\n\n
    SELECT S.Name, L.BookName, L.IssueDate\nFROM STUDENTS S\nINNER JOIN LIBRARY L ON S.StudentID = L.StudentID;\n<\/code><\/pre>\n\n\n\n
    Expected Output:<\/strong><\/p>\n\n\n\n
    Name<\/th>BookName<\/th>IssueDate<\/th><\/tr><\/thead>
    Aarav Sharma<\/td>Python Programming<\/td>2024-10-15<\/td><\/tr>
    Rohan Kumar<\/td>Data Structures<\/td>2024-10-20<\/td><\/tr>
    Diya Patel<\/td>Database Management<\/td>2024-10-18<\/td><\/tr>
    Arjun Reddy<\/td>Web Development<\/td>2024-11-01<\/td><\/tr>
    Rohan Kumar<\/td>Artificial Intelligence<\/td>2024-10-25<\/td><\/tr>
    Priya Gupta<\/td>Computer Networks<\/td>2024-11-05<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    Explanation:<\/strong> INNER JOIN returns only students who have issued books.<\/p>\n\n\n\n
    \n\n\n\n
    Q32.<\/strong> Display all students and their issued books (if any). (LEFT JOIN)<\/p>\n\n\n\n
    SELECT S.Name, L.BookName, L.IssueDate\nFROM STUDENTS S\nLEFT JOIN LIBRARY L ON S.StudentID = L.StudentID;\n<\/code><\/pre>\n\n\n\n
    Explanation:<\/strong> LEFT JOIN returns all students, even those who haven’t issued any books (NULL values).<\/p>\n\n\n\n
    \n\n\n\n
    Q33.<\/strong> Display student names with their enrolled courses.<\/p>\n\n\n\n
    SELECT S.Name, C.CourseName, C.Duration, C.Fees\nFROM STUDENTS S\nINNER JOIN COURSES C ON S.StudentID = C.StudentID;\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q34.<\/strong> Display students who have issued books along with their marks and book prices.<\/p>\n\n\n\n
    SELECT S.Name, S.Marks, L.BookName, L.Price\nFROM STUDENTS S\nINNER JOIN LIBRARY L ON S.StudentID = L.StudentID\nORDER BY S.Marks DESC;\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q35.<\/strong> Display all books and the students who issued them (if any). (RIGHT JOIN)<\/p>\n\n\n\n
    SELECT L.BookName, S.Name, L.IssueDate\nFROM STUDENTS S\nRIGHT JOIN LIBRARY L ON S.StudentID = L.StudentID;\n<\/code><\/pre>\n\n\n\n
    Explanation:<\/strong> This shows all books, including those not issued to anyone (Operating Systems and Machine Learning).<\/p>\n\n\n\n
    \n\n\n\n
    Q36.<\/strong> Display student names from Delhi who have enrolled in courses.<\/p>\n\n\n\n
    SELECT S.Name, S.City, C.CourseName\nFROM STUDENTS S\nINNER JOIN COURSES C ON S.StudentID = C.StudentID\nWHERE S.City = 'Delhi';\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q37.<\/strong> Display students who scored more than 85 and the books they issued.<\/p>\n\n\n\n
    SELECT S.Name, S.Marks, L.BookName\nFROM STUDENTS S\nINNER JOIN LIBRARY L ON S.StudentID = L.StudentID\nWHERE S.Marks > 85;\n<\/code><\/pre>\n\n\n\n
    \n
    \ud83c\udfaf Itxperts Pro Tip:<\/strong> When using joins with WHERE clause, apply the WHERE condition after the JOIN to filter the combined result.<\/p>\n<\/blockquote>\n\n\n\n
    \n\n\n\n
    Q38.<\/strong> Display total fees paid by each student for courses.<\/p>\n\n\n\n
    SELECT S.Name, SUM(C.Fees) AS TotalFees\nFROM STUDENTS S\nINNER JOIN COURSES C ON S.StudentID = C.StudentID\nGROUP BY S.Name;\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q39.<\/strong> Display students with their course names and book names.<\/p>\n\n\n\n
    SELECT S.Name, C.CourseName, L.BookName\nFROM STUDENTS S\nINNER JOIN COURSES C ON S.StudentID = C.StudentID\nINNER JOIN LIBRARY L ON S.StudentID = L.StudentID;\n<\/code><\/pre>\n\n\n\n
    Explanation:<\/strong> This is a three-table join showing complete student information.<\/p>\n\n\n\n
    \n\n\n\n
    Q40.<\/strong> Count how many books each student has issued.<\/p>\n\n\n\n
    SELECT S.Name, COUNT(L.BookID) AS BooksIssued\nFROM STUDENTS S\nLEFT JOIN LIBRARY L ON S.StudentID = L.StudentID\nGROUP BY S.Name;\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Section H: Advanced Queries (Challenge Questions)<\/h2>\n\n\n\n
    Ready to take your skills to the next level? Itxperts<\/strong> offers advanced MySQL courses for competitive programming!<\/em><\/p>\n\n\n\n
    Q41.<\/strong> Display students who have not issued any books.<\/p>\n\n\n\n
    SELECT S.Name\nFROM STUDENTS S\nLEFT JOIN LIBRARY L ON S.StudentID = L.StudentID\nWHERE L.BookID IS NULL;\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q42.<\/strong> Display the most expensive book issued to students.<\/p>\n\n\n\n
    SELECT S.Name, L.BookName, L.Price\nFROM STUDENTS S\nINNER JOIN LIBRARY L ON S.StudentID = L.StudentID\nWHERE L.Price = (SELECT MAX(Price) FROM LIBRARY WHERE StudentID IS NOT NULL);\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q43.<\/strong> Display students whose course fees are higher than average.<\/p>\n\n\n\n
    SELECT S.Name, C.CourseName, C.Fees\nFROM STUDENTS S\nINNER JOIN COURSES C ON S.StudentID = C.StudentID\nWHERE C.Fees > (SELECT AVG(Fees) FROM COURSES);\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q44.<\/strong> Display section-wise total course fees.<\/p>\n\n\n\n
    SELECT S.Section, SUM(C.Fees) AS TotalFees\nFROM STUDENTS S\nINNER JOIN COURSES C ON S.StudentID = C.StudentID\nGROUP BY S.Section;\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q45.<\/strong> Display publisher-wise book count and average price for books priced above \u20b9500.<\/p>\n\n\n\n
    SELECT Publisher, COUNT(*) AS BookCount, AVG(Price) AS AvgPrice\nFROM LIBRARY\nWHERE Price > 500\nGROUP BY Publisher;\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Section I: Nested Queries (Subqueries)<\/h2>\n\n\n\n
    Q46.<\/strong> Display students who scored more than the average marks.<\/p>\n\n\n\n
    SELECT Name, Marks FROM STUDENTS\nWHERE Marks > (SELECT AVG(Marks) FROM STUDENTS);\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q47.<\/strong> Display books more expensive than ‘Python Programming’.<\/p>\n\n\n\n
    SELECT BookName, Price FROM LIBRARY\nWHERE Price > (SELECT Price FROM LIBRARY WHERE BookName = 'Python Programming');\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q48.<\/strong> Display students enrolled in the most expensive course.<\/p>\n\n\n\n
    SELECT S.Name, C.CourseName, C.Fees\nFROM STUDENTS S\nINNER JOIN COURSES C ON S.StudentID = C.StudentID\nWHERE C.Fees = (SELECT MAX(Fees) FROM COURSES);\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q49.<\/strong> Display books issued by students from Mumbai.<\/p>\n\n\n\n
    SELECT L.BookName, S.Name, S.City\nFROM LIBRARY L\nINNER JOIN STUDENTS S ON L.StudentID = S.StudentID\nWHERE S.StudentID IN (SELECT StudentID FROM STUDENTS WHERE City = 'Mumbai');\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Q50.<\/strong> Display students who have issued more than one book.<\/p>\n\n\n\n
    SELECT S.Name, COUNT(L.BookID) AS BooksIssued\nFROM STUDENTS S\nINNER JOIN LIBRARY L ON S.StudentID = L.StudentID\nGROUP BY S.Name\nHAVING COUNT(L.BookID) > 1;\n<\/code><\/pre>\n\n\n\n
    \n\n\n\n
    Important Exam Tips from Itxperts<\/h2>\n\n\n\n
    1. Understand the Table Structure First<\/strong><\/h3>\n\n\n\n
    Before attempting any query, carefully read the table structure, column names, and relationships.<\/p>\n\n\n\n
    2. Master the Order of Execution<\/strong><\/h3>\n\n\n\n
    SQL queries execute in this order:<\/p>\n\n\n\n