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