Here is the SQL query that you need:

```sql
SELECT bill_id,
meter_id,
MONTH(due_date) AS month,
YEAR(due_date) AS year,
total_units,
payable_amount,
DATE_FORMAT(due_date, '%M %d, %Y') AS formatted_due_date
FROM bills
ORDER BY bill_id ASC;
```

This query does the following:

1. Selects the columns `bill_id`, `meter_id`, `total_units`, `payable_amount` and `due_date` from the `bills` table.
2. Extracts the month and year from the `due_date` column using the `MONTH()` and `YEAR()` functions respectively.
3. Formats the `due_date` column to the format 'Month dd, yyyy' using the `DATE_FORMAT()` function and gives it an alias `formatted_due_date`.
4. Orders the result set in ascending order by `bill_id` using the `ORDER BY` clause.

Question

Here is the SQL query that you need:

```sql
SELECT bill_id, 
       meter_id, 
       MONTH(due_date) AS month, 
       YEAR(due_date) AS year, 
       total_units, 
       payable_amount, 
       DATE_FORMAT(due_date, '%M %d, %Y') AS formatted_due_date
FROM bills
ORDER BY bill_id ASC;
```

This query does the following:

1. Selects the columns `bill_id`, `meter_id`, `total_units`, `payable_amount` and `due_date` from the `bills` table.
2. Extracts the month and year from the `due_date` column using the `MONTH()` and `YEAR()` functions respectively.
3. Formats the `due_date` column to the format 'Month dd, yyyy' using the `DATE_FORMAT()` function and gives it an alias `formatted_due_date`.
4. Orders the result set in ascending order by `bill_id` using the `ORDER BY` clause.

Knowee AI · Accepted Answer

Here is the SQL query that you need:

```sql
SELECT bill_id, 
       meter_id, 
       MONTH(due_date) AS month, 
       YEAR(due_date) AS year, 
       total_units, 
       payable_amount, 
       DATE_FORMAT(due_date, '%M %d, %Y') AS formatted_due_date
FROM bills
ORDER BY bill_id ASC;
```

This query does the following:

1. Selects the columns `bill_id`, `meter_id`, `total_units`, `payable_amount` and `due_date` from the `bills` table.
2. Extracts the month and year from the `due_date` column using the `MONTH()` and `YEAR()` functions respectively.
3. Formats the `due_date` column to the format 'Month dd, yyyy' using the `DATE_FORMAT()` function and gives it an alias `formatted_due_date`.
4. Orders the result set in ascending order by `bill_id` using the `ORDER BY` clause.

Write a query to display bill id, meter_id, month, year, total_units, payable_amount and due_date of all the bills. Display the due_date in the format like June 17, 2003. Give an alias name as 'formatted_due_date'. Display all the records sorted in ascending order based on bill id.

Question

Solution

Similar Questions

Upgrade your grade with Knowee