Scribd
Upload
13 views2 pages

6929171-Class XI-IP WS8

The document is a worksheet for Class XI Informatics Practices focusing on practical MySQL questions. It includes two tables, SPORTS and STUDENT, with various queries to be executed on them, such as displaying player details based on specific criteria and manipulating student fee data. Students are instructed to practice these queries and record their work in a record book.

Uploaded by

angela arunraj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views2 pages

6929171-Class XI-IP WS8

The document is a worksheet for Class XI Informatics Practices focusing on practical MySQL questions. It includes two tables, SPORTS and STUDENT, with various queries to be executed on them, such as displaying player details based on specific criteria and manipulating student fee data. Students are instructed to practice these queries and record their work in a record book.

Uploaded by

angela arunraj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

INDIAN SCHOOL AL WADI AL KABIR

Worksheet, 2024-25
Class: XI SUB: INFORMATICS PRACTICES Date of Completion:

Note: Practice TOPIC: Practical questions - MYSQL Note: To be written


them on in Record book
MySQL

1. Consider the following SPORTS table and write MySQL Queries for the following (i) to (x):

Admno Name DOB game Medals Class


V1237 Vanshika 2005-02-19 Tennis 3 11
S1432 Ruhaani 2005-09-11 Football 5 12
SM178 Aalam 2005-07-01 Cricket 4 11
V1935 Manan 2005-04-07 Football 6 11
S1276 Aarav 2005-10-06 Tennis 4
SM187 Rehaan 2004-12-11 Football 3 12

i) Display the Name and medals of football players from the table.
ii) Display the details of players of class 12 who have scored more than 3
medals.
iii) Display the admno, Name and game of all the players who are born
before 2005-08-12.
iv) Display the details of all the football players with the medal
in the range 2 to 4.
v) Display the different games without repetitions.
vi) Display the name ,game and medals of players who are
born after 2005-10-20.
vii) Display the details of players whose name ends with ‘an’.
viii) Display the details of players in the ascending order of their medals.
ix) Display the admno, name and medals of players who are not from
class 11.
x) Display the details of players of class 11 in the descending order of their
medals.

2. Consider the table student and write SQL queries for the following:
Table: STUDENT
SID SNAME GENDER PINCODE CITY FEE
1 Sharma F 185155 Bhawani 25000
2 Singh M 110021 New Delhi 22000
3 Alvis M 182141 Udhmwara 20000
4 Yadav F 193222 Kupwara 18000
5 Negi F 380025 null 7000
6 Pandey F 110021 New Delhi 11000
7 Sharma M 185155 Bhawani 18000

1. Display the details of male students from bhawani.


2. Display the name and fee of students whose city is not mentioned.
3. Display the name, gender and city of students in the descending order of their fee.
4. Display the name and fee of students whose name contains the letter ‘g’.
5. Display the details of students who are either from New Delhi or from Bhawani.
6. Display the name and fee of students who are not from Kurwara.
7. Display the sid, gender, city of students whose fee is in the range 10000 to 15000.
8. Display the name, gender and fee of all male students from New Delhi.
9. Display the details of students whose name does not ends with the letter ‘a’.
10. Display the name and city of all female students in the ascending order of fee.
11. Delete the details of students whose fees is less than 7000;
12. Increase the fee by 1000 for all students from New Delhi.
13. Decrease the fees of all female students by 2%.

You might also like