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
   250   251   252   253   254   255   256   257   258   259   260