Sure, here is the SQL query you asked for:

```sql
SELECT STDDEV(fine_amount) AS standard_deviation_amount
FROM bill
WHERE EXTRACT(YEAR FROM payment_date) = 2018;
```

This query works as follows:

1. `STDDEV(fine_amount) AS standard_deviation_amount`: This part of the query calculates the standard deviation of the `fine_amount` column. The `AS` keyword is used to give this calculation a more readable name, `standard_deviation_amount`.

2. `FROM bill`: This part of the query specifies the table we are selecting data from, which is the `bill` table.

3. `WHERE EXTRACT(YEAR FROM payment_date) = 2018`: This is the condition that the rows must meet to be included in the calculation. The `EXTRACT(YEAR FROM payment_date)` function gets the year part of the `payment_date` column. The `= 2018` part specifies that we are only interested in rows where the year is 2018.

Question

Sure, here is the SQL query you asked for:

```sql
SELECT STDDEV(fine_amount) AS standard_deviation_amount
FROM bill
WHERE EXTRACT(YEAR FROM payment_date) = 2018;
```

This query works as follows:

1. `STDDEV(fine_amount) AS standard_deviation_amount`: This part of the query calculates the standard deviation of the `fine_amount` column. The `AS` keyword is used to give this calculation a more readable name, `standard_deviation_amount`.

2. `FROM bill`: This part of the query specifies the table we are selecting data from, which is the `bill` table.

3. `WHERE EXTRACT(YEAR FROM payment_date) = 2018`: This is the condition that the rows must meet to be included in the calculation. The `EXTRACT(YEAR FROM payment_date)` function gets the year part of the `payment_date` column. The `= 2018` part specifies that we are only interested in rows where the year is 2018.

Knowee AI · Accepted Answer

Sure, here is the SQL query you asked for:

```sql
SELECT STDDEV(fine_amount) AS standard_deviation_amount
FROM bill
WHERE EXTRACT(YEAR FROM payment_date) = 2018;
```

This query works as follows:

1. `STDDEV(fine_amount) AS standard_deviation_amount`: This part of the query calculates the standard deviation of the `fine_amount` column. The `AS` keyword is used to give this calculation a more readable name, `standard_deviation_amount`.

2. `FROM bill`: This part of the query specifies the table we are selecting data from, which is the `bill` table.

3. `WHERE EXTRACT(YEAR FROM payment_date) = 2018`: This is the condition that the rows must meet to be included in the calculation. The `EXTRACT(YEAR FROM payment_date)` function gets the year part of the `payment_date` column. The `= 2018` part specifies that we are only interested in rows where the year is 2018.

Write a query to display the standard deviation of the fine_amount whose payment_date is on the year 2018 from bill table. Give an alias name to the standard deviation to the fine amount as 'standard_deviation_amount'.

Question

Solution

Similar Questions

Upgrade your grade with Knowee