Write a query to display the owner_name, building_type name,  meter_number and payment_status of the bill which are raised in the month December 2017.Payment_Status will be payment_date is the payment is done, else if the payment is not done then display as 'Not Paid Yet'. Give an alias name as 'Payment_Status'. Display the record in ascending order based on owner_name.Note:1. 1. Display only the below 4 columns,     i. owner_name     ii. building_type name     iii. meter_number     iv. payment_statusraised in the month december 2017.2. Use Joins3. Tables involved are bill, meter, building and building_type4. Specify condition on year, month of bill table.5. Order by is mandatory. 6. Specify the alias name without any mistake.7. Compare your executed result with the sample output given below.

The question is asking for a SQL query. Here is a step-by-step guide on how to write it:

1. Identify the tables involved: bill, meter, building, and building_type.
2. Identify the columns to be displayed: owner_name, building_type name, meter_number, and payment_status.
3. Understand the conditions: The bill should be raised in December 2017, and the payment_status should display 'payment_date' if the payment is done, else 'Not Paid Yet'.
4. Understand the order: The records should be displayed in ascending order based on owner_name.

Here is the SQL query based on the above information:

SELECT 
    b.owner_name, 
    bt.name AS building_type_name, 
    m.meter_number, 
    CASE 
        WHEN bill.payment_date IS NULL THEN 'Not Paid Yet' 
        ELSE bill.payment_date 
    END AS Payment_Status
FROM 
    bill 
JOIN 
    meter m ON bill.meter_id = m.id 
JOIN 
    building b ON m.building_id = b.id 
JOIN 
    building_type bt ON b.building_type_id = bt.id 
WHERE 
    YEAR(bill.date) = 2017 AND MONTH(bill.date) = 12 
ORDER BY 
    b.owner_name ASC;

This query first joins the necessary tables based on their relationships. It then selects the required columns, using a CASE statement to determine the Payment_Status. It filters the results to only include bills from December 2017, and finally orders the results by owner_name in ascending order.

The question is asking for a SQL query. Here is a step-by-step guide on how to write it:

1. Identify the tables involved: bill, meter, building, and building_type.
2. Identify the columns to be displayed: owner_name, building_type name, meter_number, and payment_status.
3. Understand the conditions: The bill should be raised in December 2017, and the payment_status should display 'payment_date' if the payment is done, else 'Not Paid Yet'.
4. Understand the order: The records should be displayed in ascending order based on owner_name.

Here is the SQL query based on the above information:

SELECT 
    b.owner_name, 
    bt.name AS building_type_name, 
    m.meter_number, 
    CASE 
        WHEN bill.payment_date IS NULL THEN 'Not Paid Yet' 
        ELSE bill.payment_date 
    END AS Payment_Status
FROM 
    bill 
JOIN 
    meter m ON bill.meter_id = m.id 
JOIN 
    building b ON m.building_id = b.id 
JOIN 
    building_type bt ON b.building_type_id = bt.id 
WHERE 
    YEAR(bill.date) = 2017 AND MONTH(bill.date) = 12 
ORDER BY 
    b.owner_name ASC;

This query first joins the necessary tables based on their relationships. It then selects the required columns, using a CASE statement to determine the Payment_Status. It filters the results to only include bills from December 2017, and finally orders the results by owner_name in ascending order.