Question

why do we need sorting in table and queries​

Answer 1

Answer:

You have 2 columns in table A (col1, col2) and 1 columns in table B(col3). Because of some reason you need sorting order based on ( col1*Col2 + col3). ... In some cases, sorting will be faster if done in code based on your data set. You may need different sorting algorithms for performance based on your data set.

Explanation:

Answer 2

Answer:

to arrange data in alphabetical order

Explanation:

we want to see the dances in which students are participating.We have to arrange them in alphabetical order so we have to use sorting key