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

```sql
SELECT SUM(payable_amount) AS sum_payable_amount
FROM bill
WHERE YEAR(payment_date) = 2018;
```

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

1. `SELECT SUM(payable_amount) AS sum_payable_amount`: This part of the query is asking the database to add up all the values in the `payable_amount` column and give this total the name `sum_payable_amount`.

2. `FROM bill`: This tells the database which table to pull the data from, in this case, the `bill` table.

3. `WHERE YEAR(payment_date) = 2018;`: This is the condition that the rows must meet in order to be included in the sum. The `YEAR()` function extracts the year from the `payment_date` column, and we're asking the database to only include the rows where this year is 2018.

Question

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

```sql
SELECT SUM(payable_amount) AS sum_payable_amount
FROM bill
WHERE YEAR(payment_date) = 2018;
```

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

1. `SELECT SUM(payable_amount) AS sum_payable_amount`: This part of the query is asking the database to add up all the values in the `payable_amount` column and give this total the name `sum_payable_amount`.

2. `FROM bill`: This tells the database which table to pull the data from, in this case, the `bill` table.

3. `WHERE YEAR(payment_date) = 2018;`: This is the condition that the rows must meet in order to be included in the sum. The `YEAR()` function extracts the year from the `payment_date` column, and we're asking the database to only include the rows where this year is 2018.

Knowee AI · Accepted Answer

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

```sql
SELECT SUM(payable_amount) AS sum_payable_amount
FROM bill
WHERE YEAR(payment_date) = 2018;
```

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

1. `SELECT SUM(payable_amount) AS sum_payable_amount`: This part of the query is asking the database to add up all the values in the `payable_amount` column and give this total the name `sum_payable_amount`.

2. `FROM bill`: This tells the database which table to pull the data from, in this case, the `bill` table.

3. `WHERE YEAR(payment_date) = 2018;`: This is the condition that the rows must meet in order to be included in the sum. The `YEAR()` function extracts the year from the `payment_date` column, and we're asking the database to only include the rows where this year is 2018.

Question

Solution

Similar Questions

Upgrade your grade with Knowee