Sure, here is the SQL query you asked for:

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

Please replace `your_table_name` with the actual name of your table. This query will sum up all the `payable_amount` values where the `payment_date` is in the year 2018, and the result will be labeled as `sum_payable_amount`.

Question

Sure, here is the SQL query you asked for:

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

Please replace `your_table_name` with the actual name of your table. This query will sum up all the `payable_amount` values where the `payment_date` is in the year 2018, and the result will be labeled as `sum_payable_amount`.

Knowee AI · Accepted Answer

Sure, here is the SQL query you asked for:

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

Please replace `your_table_name` with the actual name of your table. This query will sum up all the `payable_amount` values where the `payment_date` is in the year 2018, and the result will be labeled as `sum_payable_amount`.

Write a query to display the sum of payable_amount whose payment_date is on the year 2018. Give an alias name to the total payable_amount as 'sum_payable_amount'.

Question

Solution

Similar Questions

Upgrade your grade with Knowee