Extracted text: create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30) ); insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer ( customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30),
Extracted text: grade varchar(30), salesman_id int, CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id) ); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3002, 'Nick Rimando', 'New York', 100, 5001); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3007, 'Brad Davis', 'New York', 200, 5001); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3005, 'Graham Zusi', "California', 200, 5002); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3008, Julian Green', "London', 300, 5002); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3004, 'Fabian Johnson', 'Paris', 300, 5006); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3009, 'Geoff Cameron', "Berlin', 100, 5003); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3003, 'Jozy Altidor, 'Moscow', 200, 5007); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3001, 'Brad Guzan', 'London',0, 5005); SELECT s.name, c.cust_name, c.city FROM salesman s INNER JOIN customer c ON s.city = c.city; select sum(commission) as total_commission from salesman; i keep getting this message Msg 8117, Level 16, State 1, Line 55 Operand data type varchar is invalid for sum operator. can you show me what to do