Write a query to display the number of bills having fine_amount. Give an alias name as 'count_of_bills_with_fine'.

Sure, here is a SQL query that will give you the number of bills having a fine amount. The result will be displayed under the alias 'count_of_bills_with_fine'.

SELECT COUNT(*) AS count_of_bills_with_fine
FROM bills
WHERE fine_amount IS NOT NULL;

Here's the step by step explanation:

1. SELECT COUNT(*) AS count_of_bills_with_fine: This part of the query is used to count the number of rows in the table where the condition specified in the WHERE clause is true. The AS keyword is used to give the result an alias name 'count_of_bills_with_fine'.

2. FROM bills: This part of the query specifies the table from which to retrieve the data, in this case, the 'bills' table.

3. WHERE fine_amount IS NOT NULL: This is the condition for the query. It will only count the rows where the 'fine_amount' is not null, meaning there is a fine amount.