Write a query to display the total_units, payable_amount and fine_amount of bill table. Display the records in descending order based on their total_units

To achieve the desired output from the bill table, you can use the following SQL query:

SELECT 
    total_units, 
    payable_amount, 
    fine_amount 
FROM 
    bill 
ORDER BY 
    total_units DESC;

Explanation:

1. SELECT Clause: This part specifies the columns you want to retrieve from the bill table, which are total_units, payable_amount, and fine_amount.

2. FROM Clause: Indicates the table from which the data is fetched, here it is the bill table.

3. ORDER BY Clause: This orders the records by total_units in descending order (DESC), so that the records with the highest total units appear first.

This query will provide a clear view of the specified columns sorted by the number of units in descending order.