Page 96 - IPP-12-2024
P. 96

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:
   91   92   93   94   95   96   97   98   99   100   101