Page 106 - IPP-12-2025
P. 106

customer Name, country) using group by.













                ix)     Create a new table (name, date of birth) by joining two tables (student id, name) and
                       (student id, date of birth).













































                x)      Write a SQL query to order the (student ID, marks) table in descending order of the marks.














             Program 21. The table Schoolbus is as follows:
   101   102   103   104   105   106   107   108   109   110   111