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

```sql
SELECT *
FROM bills
WHERE DAY(payment_date) = 2
ORDER BY total_units DESC;
```

This query does the following:

1. `SELECT * FROM bills` selects all columns from the `bills` table.
2. `WHERE DAY(payment_date) = 2` filters the results to only include rows where the day of the month for the `payment_date` is 2.
3. `ORDER BY total_units DESC` sorts the results in descending order based on the `total_units` column.

Question

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

```sql
SELECT * 
FROM bills 
WHERE DAY(payment_date) = 2 
ORDER BY total_units DESC;
```

This query does the following:

1. `SELECT * FROM bills` selects all columns from the `bills` table.
2. `WHERE DAY(payment_date) = 2` filters the results to only include rows where the day of the month for the `payment_date` is 2.
3. `ORDER BY total_units DESC` sorts the results in descending order based on the `total_units` column.

Knowee AI · Accepted Answer

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

```sql
SELECT * 
FROM bills 
WHERE DAY(payment_date) = 2 
ORDER BY total_units DESC;
```

This query does the following:

1. `SELECT * FROM bills` selects all columns from the `bills` table.
2. `WHERE DAY(payment_date) = 2` filters the results to only include rows where the day of the month for the `payment_date` is 2.
3. `ORDER BY total_units DESC` sorts the results in descending order based on the `total_units` column.

Question

Solution

Similar Questions

Upgrade your grade with Knowee