Page 255 - IT_V1.0_Class10
P. 255
21 st
Century #Critical Thinking
B. Application-based questions. Skills
1. A teacher needs to create a list of all students in Class 10, including their names and roll numbers. The data is
stored in the Student table, which contains the fields STUD_ID, STU_NAME, CLASS, and ROLL_NO. How can the
teacher write a query to accomplish this task?
2. A store manager wants to display all products priced below ₹10,000 from the Accessories table. How can the
manager write a query in Design View to fetch this data? Additionally, the store manager also wants to retrieve a
list of products where the Product_ID starts with the letter “S.” How can this be achieved?
3. A business owner wants to calculate the total cost of products (Total_Amount) by multiplying the Quantity and
Unit_Price in the Product table. How can the owner create a query in Design View to calculate the total cost of
products? If the owner wants to filter the results to include only products where the total cost exceeds ₹5,000.
How should the query be modified to achieve this?
Queries in Base 253

