Create the following table in your database with the following schema: Table: SalesPerson | Column Name | Туре +--- | sales id | int | varchar | | int I name | salary | commission_rate | int |...

Create the tables in sql code of the attached question ?

Extracted text: Create the following table in your database with the following schema: Table: SalesPerson | Column Name | Туре +--- | sales id | int | varchar | | int I name | salary | commission_rate | int | hire_date I date +---- ----+ sales_id is the primary key column Each row of this table indicates the name and the ID of a salesperson alongside their salary, commission rate, and hire date. this table. Table: Company | Column Name | Type | int | varchar I | varchar | | com_id | name | city -----+ com_id is the primary key column for this table. Each row of this table indicates the name and the ID of a company and the city in which the company is located. Table: Orders | Column Name | Type | +- | order id | order date | com id | sales id | int | date | | int | int | int | amount +---- -----+ order id is the primary key column for this table. com id is a foreign key to com id from the Company table. sales id is a foreign key to com id from the SalesPerson table. Each row of this table contains information about one order. This includes the ID of the company, the ID of the salesperson, the date of the order, and the amount paid. Add the following data to your tables:


Extracted text: Input: SalesPerson table: +---------- | sales id | name | salary | commission rate | hire date | 1 | 2 | 3 | 4 | 5 | John | 100000 | 6 | 12000 | Mark | 65000 | 25000 | Alex | 5000 | 5 | 12 | 25 | 10 | 4/1/2006 | 5/1/2010 | 12/25/2008 I | 1/1/2005 | 2/3/2007 | Amy | Pam +--- Company table: +--- com_id | name | city | 1 | 2 | 3 | 4 | RED | ORANGE | New York | | YELLOW | Boston | GREEN | Boston | Austin +-- Orders table: +--------- | order id | order date | com id | sales id | amount | +-- -------+ | 1 | 2 | 3 | 4 | 1/1/2014 | 2/1/2014 | 3/1/2014 | 4/1/2014 | 3 | 4 | 1 | 1 | 4 | 5 | 1 | 4 | 10000 | 5000 | 50000 | 25000 Write an SQL query to report the names of all the salespersons who did not have any orders related to the company with the name "RED". Return the result table in any order. The results should be: Output: +---- | name | +------+ | Amy | Mark | | Alex | +------+