Write a query to display the month and sum of fine_amount collected on the month between July to October. Give an alias name as 'monthly_fine_amount' also display the records in ascending order based on month.Note:1. Display only the month and sum of fine_amount collected in the month between July to October from bill table. (month will be 01, 02, 03,...12)2. Specify the alias name without any mistake.3. Order by is mandatory4. Group by month to get the month wise sum of fine_amount5. Compare your executed result with the sample output given below.

The query you're asking for would look something like this:

SELECT 
    MONTH(bill_date) AS month, 
    SUM(fine_amount) AS monthly_fine_amount
FROM 
    bill
WHERE 
    MONTH(bill_date) BETWEEN 7 AND 10
GROUP BY 
    MONTH(bill_date)
ORDER BY 
    MONTH(bill_date);

Here's a step-by-step breakdown of this query:

1. SELECT MONTH(bill_date) AS month, SUM(fine_amount) AS monthly_fine_amount: This line is selecting the month from the bill_date column and the sum of the fine_amount column. The AS keyword is used to give these selected columns new names (or aliases), month and monthly_fine_amount.

2. FROM bill: This line is specifying the bill table as the source of the data.

3. WHERE MONTH(bill_date) BETWEEN 7 AND 10: This line is filtering the data to only include records where the month of the bill_date is between July (7) and October (10).

4. GROUP BY MONTH(bill_date): This line is grouping the selected data by the month of the bill_date, which allows the SUM(fine_amount) to calculate the total fine amount for each month.

5. ORDER BY MONTH(bill_date): This line is ordering the results by the month of the bill_date in ascending order (from July to October).

The query you're asking for would look something like this:

SELECT 
    MONTH(bill_date) AS month, 
    SUM(fine_amount) AS monthly_fine_amount
FROM 
    bill
WHERE 
    MONTH(bill_date) BETWEEN 7 AND 10
GROUP BY 
    MONTH(bill_date)
ORDER BY 
    MONTH(bill_date);

Here's a step-by-step breakdown of this query:

1. SELECT MONTH(bill_date) AS month, SUM(fine_amount) AS monthly_fine_amount: This line is selecting the month from the bill_date column and the sum of the fine_amount column. The AS keyword is used to give these selected columns new names (or aliases) for this query.

2. FROM bill: This line is specifying the table that we're selecting data from, which is the bill table.

3. WHERE MONTH(bill_date) BETWEEN 7 AND 10: This line is filtering the data so that only rows where the month of the bill_date is between July (7) and October (10) are included.

4. GROUP BY MONTH(bill_date): This line is grouping the selected data by the month of the bill_date, which allows us to calculate the sum of the fine_amount for each month.

5. ORDER BY MONTH(bill_date): This line is ordering the results by the month of the bill_date in ascending order.

Please replace bill_date and fine_amount with your actual column names if they are different.