Write the SQL query to get the customer number, customer name, phone, country, sales representative, employee number, first name and last name of the sales representative, and their office's country for those customers that do not have any payment and the office of the sales representative is 'France'. MYSQL Sample Database Diagramproductlines*productLinetextDescriptionhtmlDescriptionimageproductsorderdetailsproductCodeproductNameproductLineproductScaleproductVendorproductDescriptionquantitylnStockbuyPriceMSRP* orderNumberproductCodequantityOrderedpriceEachorderLineNumberemployees* employeeNumberlastNamefirstNameextensionordersorderNumberorderDateemailcustomersrequiredDateshippedDateofficeCodereportsTojobTitlecustomerNumbercustomerNamestatuscontactl.astNamecommentscontactFirstNamecustomerNumberphoneaddressLine1officesofficeCodeaddressLine2citycityphoneaddressLine1addressLine2paymentscustomerNumbercheckNumberstatepostalCodecountrysalesRepEmployeeNumbercreditLimitpaymentDatestateamountcountrypostalCodeterritory主

Answered: SQL query to get the customer number,…

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

Concept explainers

Question

Write the SQL query to get the customer number, customer name, phone, country, sales representative, employee number, first name and last name of the sales representative, and their office's country for those customers that do not have any payment and the office of the sales representative is 'France'.

MYSQL Sample Database Diagram
productlines
*productLine
textDescription
htmlDescription
image
products
orderdetails
productCode
productName
productLine
productScale
productVendor
productDescription
quantitylnStock
buyPrice
MSRP
* orderNumber
productCode
quantityOrdered
priceEach
orderLineNumber
employees
* employeeNumber
lastName
firstName
extension
orders
orderNumber
orderDate
email
customers
requiredDate
shippedDate
officeCode
reportsTo
jobTitle
customerNumber
customerName
status
contactl.astName
comments
contactFirstName
customerNumber
phone
addressLine1
offices
officeCode
addressLine2
city
city
phone
addressLine1
addressLine2
payments
customerNumber
checkNumber
state
postalCode
country
salesRepEmployeeNumber
creditLimit
paymentDate
state
amount
country
postalCode
territory
主

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

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