Question

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

Answer 1

The SQL ORDER BY Keyword

The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.

The ORDER BY statement in sql is used to sort the fetched data in either ascending or descending according to one or more columns.

1. By default ORDER BY sorts the data in ascending order.
2. We can use the keyword DESC to sort the data in descending order and the keyword ASC to sort in ascending order.

Answer 2

Explanation:

Since

C

P

,

C

Q

and

C

R

are radii of the same circle then they must be equal, therefore,

C

P

=

C

Q

and

C

P

=

C

R

Now since

∠

P

Q

C

=

25

0

, therefore,

∠

C

P

Q

=

25

0

and

since

∠

P

R

C

=

15

0

, therefore,

∠

C

P

R

=

15

0

soceles triangle property)

Now,

∠

Q

P

R

can be determined as follows:

∠

Q

P

R

=

∠

C

P

Q

+

∠

C

P

R

=

25

0

+

15

0

=

40

0

Hence,