Q20. Consider the following Table 'PROD_DETAILS".

PRODUCT ID

157

289

340

567

845

PNAME

PRICE

PDATE

03-12-2022

KEYBOARD

8000.00

MOUSE

5600.00

12-02-2021

RAM

HDD

3000.00

7800.00

01-22-2022

06-07-2021

COOLER

6500.00

08-11-2021

Write the SQL commands to perform the following tasks.

(i) Display the product id and half the price of all the products whose price is above 5000.

(ii) Query to view the records in descending order with respect to Product names

(iii) Delete the products with a price less than 8000.​