Page 40 - IPP-12-2025
P. 40

Consider the following tables:
                    Table 1:
                    SUPPLIER,  which  stores  Supplier_ID,  Supplier_Name,  Contact_Number.  The  table  displays  basic
                    information of the suppliers.
                    Table 2:
                    INVENTORY,  which  stores  Product_ID,  Supplier_ID,  Product_Name,  Stock_Quantity.  The  table  displays
                    the stock of the products.
                                                         Table: SUPPLIER
                                     Supplier_ID     Supplier_Name        Contact_Number
                                        S001     Neon Pvt. Ltd.         9891567854
                                        S002     Invent Ltd.            8800764521
                                        S003     Tech Supplies          9811506118
                                        S004     Mega Traders           8370899011

                                                        Table: INVENTORY
                                   Product_ID      Supplier_ID   Product_Name    Stock_Quantity
                                     PD1001      S001            Laptop         50
                                     PD1002      S002            Smartphone     200
                                     PD1003      S003            Headphones     100
                                     PD1004      S004            Laptop         30
                                     PD1005      S001            Smartphone     150

                    Write appropriate SQL queries for the following:
                     (a) Display the total stock quantity for each product.
                     (b) List all products supplied by ‘Neon Pvt. Ltd.’ in lowercase.
                     (c) Display the product name along with the contact number of the supplier.


                                                    Section D (2 × 4 = 8 Marks)
                 33. Sarika, a data analyst, is creating a report to visualize the sales performance of four products in the last
                    quarter. The sales data (in thousands) is as follows:                                     [4]

                                                     Product     Sales (in thousands)
                                                    Product A   50
                                                    Product B   75
                                                    Product C   100
                                                    Product D   60

                    Help Sarika complete the following Python code to generate the given bar chart:
























                                                                                       Practice Paper        P.13
   35   36   37   38   39   40   41   42   43   44   45