Question: sql quickly please 8. Write a SQL query to find the list of customers who appointed a salesman for their jobs who does not live

sql quickly please

8. Write a SQL query to find the list of customers who appointed a salesman for their jobs who does not live in the same city where their customer lives. Use the tables customer and salesman. IMA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write a SQL statement to find the list of customers who appointed a salesman for their jobs who gets a commission from the company is more than 12%. Customer table customer_id cust_name city grade...

Question. Given the structure of inventory database, answer the following: salesman Y SALESMAN_ID NAME CITY COMMISSION NUMERIC (5) VARCHAR 30 ) VARCHAR ( 15 ) DECIMAL(5.2) customer Y CUSTOMER D...

Background on SQL Server: Microsoft SQL Server is a popular enterprise-class DBMS that has been around for many years. SQL Server really handles SQL well, better than simpler tools such as Microsoft...

Q1 Create a report showing ALL data from the ORDERITEMS table. Q2 List the publisher names only from the PUBLISHER table. Q3 List the contact name and the phone number for each publisher in the...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

-- DDL for Table CUSTOMERT -------------------------------------------------------- CREATE TABLE "CUSTOMERT" ("CUSTOMER_ID" NUMBER(5,0), "CUST_NAME" VARCHAR2(30), "CITY" VARCHAR2(15), "GRADE"...

I need help writing the code in Codio with the instructions attached. I also attached a screenshot of the error code that I was given. Terminal X mysql> USE QuantigrationRMA; Reading table...

Hello, below I have a database which I've created below and also all of the foreign key constraints. I need help with two things: One, I can't seem to see the logic on which tables to drop first and...

Hi. I'm asked to take this class for graduation but I don't know how to do any of this. Please help me! I'm already devastated with the whole concept and Finance is new to me. Idk what I'm doing in...

Fact Find Initial Interview: Time Date Location Referred by: A. Personal Details Applicant 1 Applicant 2 Full Name of Applicant Full Name of Applicant Mr Mrs Miss OMS Dr Mr Mrs Miss OMs Dr Full Name...

For a Markov chain with each of the transition probability matrices in (a)( c), find the communicating classes and the periodicity of the various states. (a) (b) (c) 0 1001-3 0 0 1-2 1-3 011-2 1-3...

The firm of Smith & Roberson, CPA's has offices located in Phoenix, Salt Lake City, and Denver. The Denver office handles the audit of Aspen Resorts, Inc. Kramer is a partner in the Denver office...

The basic approach in product costing is to allocate costs in the cost pools to individual cost drivers allocation bases objects

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

1 Does it surprise you that vacation time is not mandated in the United States but is mandated in most other wealthy nations? Do you think that Americans would be more or less productive if they had...

Have you ever been involved in a mentoring relationship? If so, did you find that this relationship benefited you in any way? Did it benefit your organization as well? How would you describe the...

A Do you think that organizations benefit more from having employees work face to face or from having employees work from home? Does it have to be one way or the other?