Write a query to display all the details of all the 'bills' whose payment_date is on the year 2018, sorted by payable_amount in descending order

To achieve this, you can use the SQL query below to select and display all the details of bills with a payment_date in the year 2018, sorted by payable_amount in descending order.

SELECT *
FROM bills
WHERE YEAR(payment_date) = 2018
ORDER BY payable_amount DESC;

Explanation:

1. *SELECT : This command selects all columns from the bills table.
2. FROM bills: This specifies the table from which to retrieve the data.
3. WHERE YEAR(payment_date) = 2018: This condition filters the results to only include bills where the payment_date falls in the year 2018.
4. ORDER BY payable_amount DESC: This sorts the filtered results by the payable_amount in descending order, meaning higher amounts will appear first.

Make sure to run this query in your SQL environment to view the results.