create database GA2gouse GA2gocreate 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), 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', 'NewYork', 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.cityFROM salesman sINNER JOIN customer cON s.city = c.city;select sum(commission) as total_commission from salesman;i keep getting this messageMsg 8117, Level 16, State 1, Line 55Operand data type varchar is invalid for sum operator.can you show me what to do

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);

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);

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name…

A: In the given Customer table creation query, salesman_id is a foreign key. But the given syntax of…

Q: assume that a database has a table named Stock, with thefollowing columns:Column Name…

A: Select statement is used for selecting data from the database. Syntax: SELECT column1, column2,…

Q: How do you map a "Many to Many" relationship when mapping ER Diagram to Schema Select one: O a. Take…

A: How do you map many to many relationship when mapping ER diagram. Many to many relation happens when…

Q: Create a store procedure that displays the names of salesman located in Paris and their commission

A: Stored Procedure: It is a prepared SQL code that you can save, so the code can be reused over and…

Q: CREATE TABLE EMPLOYEE( ENUM DECIMAL(12) NOT NULL,/* Employee number */ FNAME VARCHAR(50) NOT NULL,/*…

A: the answer is:

Q: i keep getting this message Msg 1778, Level 16, State 0, Line 23 Column 'salesman.salesman_id' is…

A: Given error is Column 'salesman.salesman_id' is not the same data type as referencing column…

Q: DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY…

A: Answer in step 2

Q: When all the elements you want to query belong to the same namespace, declaring a default element…

Q: assume that a database has a table named Stock, with thefollowing columns:Column Name…

A: “SELECT” statement is used for selecting data from the database. Syntax: To select particular…

Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name…

A: Please refer to the following step for the complete solution of the problem above.

Q: Sales Database: Customers(custId, lastName, firstName, address, phone, creditLimit)…

A: A Sales Database consisting of three tables: Customers, Orders, and Items. The table structures and…

Q: Write a SQL Query to create a Schedule table, with columns: HorseID - integer with range 0 to 65535,…

A: To create a table in SQL, we use the CREATE TABLE statement followed by the table name and a list of…

Q: EventHelpers is a company that specializes in event medical assistance. They can handle any type of…

A: ER: It is outlined as associate Entity–relationship model (ER model) describes the structure of a…

Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name…

A: As per the given data, while creating salesman table, you have declared commission with datatype…

Q: Description The Employee table holds all employees including their managers. Every employee has an…

A: SQL query : -

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

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),

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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

SQL CODE FOR For the players who show up in Batting, Bowling, and Fielding tables, create a list that shows their names, runs they have scored, wickets they have taken, and catches they have taken? table is in picture (bowling table is same as batting and fielding )
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns all the columns from the rows where Trading_Symbol starts with "SU".
Assume that a database has a table named Stock, with the following columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price moneyWrite a Select statement that returns the Trading_Symbol column only from the rows where Purchase_Price is greater than $25.00.
Assume that the Authors table is already built in the database with the following specifications: Authors: Column Name Data Type constrains Authors ID Author Name Varchar2(10) |Varchar2(30) Primary key Unique You Need to Create the Books table with the following specifications Column Name Data Type Constrains ISBN Book Title Book Price Author id Number (10) Varchar2(40) Number (4,2) Varchar2(10) Primary key Not Null referencing the Author_ID in the Author Table Complete the create statement by drag and drop the correct word: Create Table lblank (ISBN Number (10) plank, Book Title Varchar2blank ) Not Null, Book Price Number(4, 2), Auther IR blank (10) references Jolank (blank ); Author ID Books Number||Authors Not Nul Varchar2| Primary Key 40 h (United States)
PROBLEM -1 The table name is "users" and its structure is shown below. You can insert as many rows in your database as you want to check your queries. ID int Name varchar(100) Email varchar(50) Influence_count int Member_since date Multiplier int Task Find all the unique multipliers in the table and show them in descending order. Find the names where multipliers are odd. Find the name, email and member_since of users who became a member of the platform between 31st of July, 2020 and 15th of August, 2020 Show the name and email of the latest 5 members. Find all ids and email addresses where the TLD (Top Level Domain) is 'com' (ends with 'com') Show the name and email of the person who has the highest number of influence counts. Retrieve the id, name, email and influence count of the users who have 'u,o,v,n,s,m' - all of these in their name. Find highest influence_count for each multiplier that is greater than 9. Count the number of users in each multiplier who has joined after the month…
SQL Database help
Q2: Design Database for the following scenario and Write SQL queries. Create an ERD for the following scenario. Suppose there is a grocery store near your house. Following can be considered for ERD: A grocery store may have more than one employee. A grocery store has exactly one manager. The manager has one or more sales men working under him. Grocery store has more than one portion for the products. • Each product has a barcode, name, expired date. Many customers can busy many products, but each product is bought by only one customer. Each customer will get an invoice for his /her purchase. The bill invoice has an id.
SQL A table Products have: a name (TEXT) a description (TEXT) a unit cost stored in cents (INTEGER) and of course we also add an id column to identify them. Separately, we'd like to track the number of items in stock for each product. To do so we'll have a store and an inventory table. Stores have just an id and a name. Then, our inventory table should combine stores and products, listing how much of each product each store has in stock. a product_id (INTEGER) a store_id (INTEGER) a quantity (INTEGER) in stock Now we can insert some stores, products and inventory into our database. There are 2 stores -- one called NY and one called NJ. There are 2 products we are concerned with. Their names are sneakers, costing $220 (remember this is dollars!) and boots costing $350. Use any description for each that you'd like. NY has 4 sneakers in stock and 3 boots. NJ has 5 sneakers in stock and no boots. Insert the above data into the tables you have created.
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns the Trading_Symbol column and the Num_Shares column from every row in the table.
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns the Trading_Symbol column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100.
Composite main keys have prospective keys.
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Create a new table to store maintenance operations Test Query DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL MAINTENANCE_TYPE_ID char(5) NO PRI NULL MAINTENANCE_DUE date NO PRI NULL