Page 95 - IPP-12-2024

v) Write a query to display the minimum, maximum, total and average marks of the
students.

vi) Create a new table (order ID, customer Name, and order Date) by joining two tables
(order ID, customer ID, and order Date) and (customer ID, customer Name).

vii) Create a foreign key in one of the two tables mentioned above.

viii) Find the total number of customers from each country in the table (customer ID,