Generate a list of salespeople and
sort it in descending order by hire date. Show the first name, last name, hire
date, and salary for each salesperson.
Generate a list of customers whose
last name begins with the letter “M.” Show the first and last names of these
customers. Sort the list of customers in descending order by last name.
Generate a list of customers with
annual incomes greater than $80,000 who purchased cars from salesperson
“Katie.” Show the first name, last name, and annual income of each of these
Which customers purchased vehicles
from salesperson “Dudley” despite having a “Poor,” “Very Poor,” or “Extremely
Poor” credit rating? Show the first name, last name, and credit description for
Salesperson Colin recently had an
encounter with a customer who he would like to contact again. Unfortunately,
Colin can’t remember if the customer’s last name was “Hansen” or “Hanson.”
Construct a query to help Colin find the correct customer to follow up with.
Show the customer’s first name, last name, and phone number.
Construct a query to count how
manyencounters resulted in
the customer declining to make a purchase. Use the COUNT function. (Hint: a
customer can have many encounters)
Customers with low annual income or
poor credit ratings often have trouble qualifying for credit. A new, local
credit agency may be better able to serve this market segment than the current
options can. The manager would like to talk to a few salespeople who have had
the most encounters with these customers. Create a list that shows each
salesperson (first and last name) and the number of encounters each has had
with customers that have an annual income of $25,000 or less or have a credit
description that is “Very Poor” or “Extremely Poor.” Order the results
alphabetically by the salesperson’s last name. Your query should have three
columns: sFirstName, sLastName, encounter_count.
Generate a query to find the average
income of customers who purchased a car on their interaction.
Construct a query to show customers
with an annual income greater than $100,000 who have a credit rating of “Fair,”
“Poor,” “Very Poor,” or “Extremely Poor.” Show each customer’s first name, last
name, credit description, and annual income.
Management is considering
closing on Sundays and would like to have a feeling for the kinds of customers
that come to the dealership on Sunday. Create a totals query that shows the
count of encounters on the Sundays of July 2015—grouped by the credit
description held by the customer of the encounter. The Sundays in July of 2015
are the 5th, 12th, 19th, and 26th.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more