HomeworkLib
Question

Write an SQL statement that will: List the salesmen that have sold autos with rebate amounts...

Write an SQL statement that will:

List the salesmen that have sold autos with rebate amounts greater than $3500.

Use the following database schema to write your SQL statement.

AUTOS (AutoID, Make, Model, Year, MSRP, RebateID)
SALESMAN (SMID, SMFName, SMLName, MgrID)
MANAGER (MgrID, MgrFName, MgrLName)
REBATE (RebateID, Description, RebateAmount)
AUTOSALES (AutoID, CustomerID, SalesDate)
CUSTOMER (CustomerID, CustFName, CustLName, Email, SMID)

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Solution

Select SALESMAN.SMID,SALESMAN.SMFName,SALESMAN.SMLName

From SALESMAN,CUSTOMER,AUTOSALES , AUTOS, REBATE

Where SALESMAN.SMID=CUSTOMER.SMID And CUSTOMER.CustomerID=AUTOSALES.CustomerId And AUTOSALES.AutoID= AUTOS.AutoID AND AUTOS.RebateID= REBATE.RebateID And REBATE.RebateAmount>3500

Explanation

We are doing the cross product of tuples from SALESMAN,CUSTOMER,AUTOSALES , AUTOS and REBATE tables and in the where condition we choose the correct tuples by equating respective attributes from different tables and selecting RebateAmount>3500. For these set of tuples we are printing the SMID,SalesmanFirstName and SalesmanLastName.

0 0
Add a comment
Know the answer?
Add Answer to:
Write an SQL statement that will: List the salesmen that have sold autos with rebate amounts...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • NEED THE SQL QUERIES ASAP PLEASE(LIKE 1 HOUR) THE ONES WITH ID ARE PRIMARY KEYS OR...

    NEED THE SQL QUERIES ASAP PLEASE(LIKE 1 HOUR) THE ONES WITH ID ARE PRIMARY KEYS OR FOREIGN etc Customer [ CustID, LastName, FirstName, Address, City, State, Zip, Phone, Fax, Email] Product [ ProdID, Description, Color, Size, Pack] Sales [ TransID, CustID, ProdID, Price, Quantity, Amount] Write SQL statement to produce a list of unique products and their prices from the Sales table. Please ensure that the products do not repeat. Write an SQL statement to list ProdID and Description for...

  • Consider the following database and answer the questions below. a) Write the SQL statement the displays...

    Consider the following database and answer the questions below. a) Write the SQL statement the displays the names of the students who have enrolled in the Database Systems course b) Write the SQL statement that displays a list of the students whose names start with 'S' c) Write the SQL statement that displays the Student ID, Student Name, Course ID, and Grade for students that passed at least one course with a grade better than B+ (i.e. A-, A, and...

  • A database used for a toy store that keeps track of the inventory and purchase orders...

    A database used for a toy store that keeps track of the inventory and purchase orders from the store. All clients will have their membership ID card to shop. This database will help the store to keep track of their orders. It will also help the store to know how many products are available in the inventory. It is necessary to have a membership to purchase a product. The customer can also bring coupons to get discount. Key attributes: Salesman:...

  • A database used for a toy store that keeps track of the inventory and purchase orders...

    A database used for a toy store that keeps track of the inventory and purchase orders from the store. All clients will have their membership ID card to shop. This database will help the store to keep track of their orders. It will also help the store to know how many products are available in the inventory. It is necessary to have a membership to purchase a product. The customer can also bring coupons to get discount. Key attributes: Salesman:...

  • solve: Write a single SQL statement to create a new table named Login with five columns:...

    solve: Write a single SQL statement to create a new table named Login with five columns: User(Text), Password (Text), Update (Date), Status (Text) and CustomerID (Integer) Set the default value of LastUpdate to the current date and time ( time) Define a check on Status to make sure the value could either be 'active' or 'inactive' and Write a single SQL statement to list all the tracks that have the exact word 'hello' (including both upper and lower cases) as...

  • There are 7 problems that require using joins. Each problem has 10 points. 1. Write an...

    There are 7 problems that require using joins. Each problem has 10 points. 1. Write an SQL command that will find any customers who have not placed orders and sort them out by CustomerID in ascending order. 2. List the employees and supervisors names for each supervisor who supervises more than two employees. 3. List the name of each employee, his or her birth date, the name of his or her manager, and the manager’s birth date for those employees...

  • For the below `bank' schema: customer(customerid,username,fname,lname,street1,street2,city,state,zip) account(accountid,customerid,description,) transaction(transactionid,trantimestamp,accountid,amount) A customer may have several accounts, and each...

    For the below `bank' schema: customer(customerid,username,fname,lname,street1,street2,city,state,zip) account(accountid,customerid,description,) transaction(transactionid,trantimestamp,accountid,amount) A customer may have several accounts, and each account may participate in many transactions. Each transaction will have at least two records, one deducting amount from an account, and one adding amount to an account (for a single transactionid, the sum of amounts will equal zero). Using SQL, answer these questions (write a SQL query that answers these questions): 8) List the top 1% of customers (ordered by total balance). 9) Using...

  • Write a sql query that returns Which states have more than one customer? List the states and the ...

    write a sql query that returns Which states have more than one customer? List the states and the number of customers for those states. The list must not include the states that do not have more than one customer. CUSTOMER_T CustomerName, Street, City, State, Zip,

  • write a sql query that returns Which states have more than one customer? List the states...

    write a sql query that returns Which states have more than one customer? List the states and the number of customers for those states. The list must not include the states that do not have more than one customer. CUSTOMER_T CustomerName, Street, City, State, Zip,

  • I can provide my log in to my teradata database if necessary. Thanks 19:31 P B...

    I can provide my log in to my teradata database if necessary. Thanks 19:31 P B . Ch. 6 HW Assignment 4 - Saved SG 59% Make db_pvfc11_big as your default database when you log into SQL Assistant: Username userid Password: Default Database: db pufc11_big Database Descriptions Provide proof of ownership by using Current_User attribute in all SELECT statements. Use the PVFC database to answer the following questions: 1. For each customer, list the CustomerID and the total number of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT