I'm sorry, but you didn't provide a specific question or the structure of the tables. However, I can provide a general SQL query that might help you.

Assuming you have two tables: 'salesman' with a column 'name' and 'orders' with columns 'salesman_name' and 'purchase_amount', you can create a view named 'norders' as follows:

```sql
CREATE VIEW norders AS
SELECT s.name, ROUND(AVG(o.purchase_amount), 2) AS average_purchase, SUM(o.purchase_amount) AS total_purchase
FROM salesman s
JOIN orders o ON s.name = o.salesman_name
GROUP BY s.name;
```

This SQL statement creates a new view 'norders'. It selects the name from the 'salesman' table and calculates the average and total purchase amounts from the 'orders' table for each salesman. The 'ROUND' function is used to round the average purchase amount to 2 decimal places. The 'JOIN' clause is used to combine rows from both tables based on the salesman's name. The 'GROUP BY' clause is used to group the result-set by one or more columns, in this case, the salesman's name.

Please replace the table and column names with your actual table and column names.

Question

I'm sorry, but you didn't provide a specific question or the structure of the tables. However, I can provide a general SQL query that might help you.

Assuming you have two tables: 'salesman' with a column 'name' and 'orders' with columns 'salesman_name' and 'purchase_amount', you can create a view named 'norders' as follows:

```sql
CREATE VIEW norders AS
SELECT s.name, ROUND(AVG(o.purchase_amount), 2) AS average_purchase, SUM(o.purchase_amount) AS total_purchase
FROM salesman s
JOIN orders o ON s.name = o.salesman_name
GROUP BY s.name;
```

This SQL statement creates a new view 'norders'. It selects the name from the 'salesman' table and calculates the average and total purchase amounts from the 'orders' table for each salesman. The 'ROUND' function is used to round the average purchase amount to 2 decimal places. The 'JOIN' clause is used to combine rows from both tables based on the salesman's name. The 'GROUP BY' clause is used to group the result-set by one or more columns, in this case, the salesman's name.

Please replace the table and column names with your actual table and column names.

Knowee AI · Accepted Answer

I'm sorry, but you didn't provide a specific question or the structure of the tables. However, I can provide a general SQL query that might help you.

Assuming you have two tables: 'salesman' with a column 'name' and 'orders' with columns 'salesman_name' and 'purchase_amount', you can create a view named 'norders' as follows:

```sql
CREATE VIEW norders AS
SELECT s.name, ROUND(AVG(o.purchase_amount), 2) AS average_purchase, SUM(o.purchase_amount) AS total_purchase
FROM salesman s
JOIN orders o ON s.name = o.salesman_name
GROUP BY s.name;
```

This SQL statement creates a new view 'norders'. It selects the name from the 'salesman' table and calculates the average and total purchase amounts from the 'orders' table for each salesman. The 'ROUND' function is used to round the average purchase amount to 2 decimal places. The 'JOIN' clause is used to combine rows from both tables based on the salesman's name. The 'GROUP BY' clause is used to group the result-set by one or more columns, in this case, the salesman's name.

Please replace the table and column names with your actual table and column names.

From the following table, create a view named norders that provides a summary of the average and total purchase amounts for each salesman. The view should include the salesman's name along with the rounded average and total purchase amounts.Sample Table: salesmanSample Table: orders

Question

Solution

Similar Questions

Upgrade your grade with Knowee