Question
1. Write a query to display the customer name for all customers that are not from the USA that have not placed any order. Order
1. Write a query to display the customer name for all customers that are not from the USA that have not placed any order. Order the results by customer name in the ascending order.
2. Write a query to display the name (last name and first name) of the employee and the amount of business they have generated (i.e. how many dollars worth of product has an employee sold) as a percentage of the total sales volume. Make sure you have a rounded result to decimal places with a % sign at the end. Order the results in descending value of dollars worth of products sold.
Payments check Number paymentDate amount customerNumber Offices officeCode city phone addressLine1 addressLine2 state country postalCode territory officeLocation > Employees employee Number lastName firstName Customers customerNumber customerName contactLastName contactFirstName phone addressLine1 addressLine2 city state postalCode country sales RepEmployeeNumber creditLimit customerLocation > - - - - - - -O+ extension email reportsTo job Title officeCode ProductLines productLine textDescription Order Details 1 orderNumber Orders order Number order Date requiredDate shipped Date status comments productCode quantity Ordered priceEach orderLine Number Products productCode productName productScale productVendor productDescription quantityInStock buy Price MSRP productLine customerNumberStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started