Create SQL for the following: Construct a query to show customers with an annual income greater...
Create SQL for the following: 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.
Homework Answers
If you have any doubts, please give me comment...
SELECT firstName, lastName, creditDescription, annualIncome
FROM Customer
WHERE annualIncome>100000 AND creditRating IN ("Fair", "Poor", "Very Poor", "Extremely Poor");
Add Answer to:
Create SQL for the following: Construct a query to show
customers with an annual income greater...
Can you please write the MySQL Query sentences for the following items below? For example: SELECT...
Can you please write the MySQL Query sentences for the following items below? For example: SELECT * FROM employees; Generate a list of salespeople sorted descending by hire date. Show the ID, 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 descending by last name. C. Generate a list of customers...
SQL Queries – in this assignment you will be asked to create several SQL queries relating...
SQL Queries – in this assignment you will be asked to create several SQL queries relating to the Sakila database that we installed in class. You may freely use DBeaver to create these queries, but I will expect your solution to show me the SQL code to answer or complete the tasks below. Write a query that produces the last name, first name, address, district, and phone number for every customer in the customer table. (You don’t need to include...
I need to create a SQL query that displays the names of the customers who purchased...
I need to create a SQL query that displays the names of the customers who purchased the book with the highest retail price in the database. Also I need to capitalize the first and last names. CUSTOMERS Table: CUSTOMER#, LASTNAME, FIRSTNAME, ADDRESS, CITY, STATE, ZIP, REFERRED, REGION, EMAIL ORDERS Table: ORDER#, CUSTOMER#, ORDERDATE, SHIPDATE, SHIPSTREET, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPCOST ORDERITEMS Table: ORDER#, ITEM#, ISBN, QUANTITY, PAIDEACH
You have been asked to create a query that will join the Production.Products table with the...
You have been asked to create a query that will join the Production.Products table with the Production.Categories table. From the Products table show the product name and unit price. From the Categories table show the category name and description. For the query sort by two columns: first by category name in ascending order and then by unit price in descending order. Provide the full SQL statement for the answer. TSQLV4
j. Create a SQL query based on tblTransaction and tblEmployees that will display all the fields...
j. Create a SQL query based on tblTransaction and tblEmployees that will display all the fields from tblTransaction and the FirstName and LastName fields from tblEmployees. Use a join to include all employees, regardless if they have sold any products. Sort in ascending order by the employee’s first name and last name. Save your query as qryEmpTransaction_initialLastname, and then close the query. Feilds from tbl Transaction are TransactionID, CustomerID, EMployeeID, TransactionDate, MethodOfPayment Feilds from tbl Employees are EmployeeID, FirstName, LastName,...
Write a SQL query that shows the price of each order made by customers whose last name starts wit...
Write a SQL query that shows the price of each
order made by customers whose last name starts with the
letter M. Display the order number, the last name on the order, and
the price of the order (Order Price). Show the results with the
highest order price first.
Write a SQL query that determines the most
expensive item purchased in each order (Item Price). Display the
order number, the date of the order, the last name of the customer...
can someone solve these quick please and thank you! sql chapter 4 Query #1: List the...
can someone solve these quick
please and thank you!
sql chapter 4
Query #1: List the company name, contact name, contact title and
the phone number for customers who HAVE NOT put in an order. Use an
outer join.
Query #2: Create a listing displaying the employee first name,
last name and the full name (First name space Last Name) of the
person they report to (Supervisor). This is a self-join. If an
employee does not report to anyone then...
Create an SQL Query to show how many customers there are in each state. Sample results ST CUST_C...
Create an SQL Query to show
how many customers there are in each state.
Sample results
ST CUST_COUNT
-- ----------
CA 1
GA 1
CO 2
DC 1
WA 4
BC 1
CUSTOMER CustomerlD ARTIST TRANS WORK SArtistID LastName PURCHASES/SOLD TO Q TransactionID ACQUIRED OworkID CREATES/CREATEDBY FirstName AreaCode LocalNumber Street City State ZipPostalCode Country Email (AK1.1) DateAcquired AcquisitionPrice DateSold SalesPrice AskingPrice WorkID (FK) CustomerlD (FK) Title (AK1.1) o- Copy (AK1.2) Medium Description ArtistID (FK) LastName (AK1.1) FirstName (AK1.1) Nationality DateOfBirth...
Need the SQL query for the questions below 1) Print the name of customers who do...
Need the SQL query for the questions below
1) Print the name of customers who do not live
in MPLS or Edina, have a loan with an amount of more than 500 in
any branch of the bank but not in the France branch, and have one
or more accounts only in the France branch.
2) Show the name of all Customers who have only
one account with a balance of more than $1000 in any branch of the
bank...
USING SQL 4. Show me the maximum rental duration and minimum rental duration from the film...
USING SQL 4. Show me the maximum rental duration and minimum rental duration from the film table. Name the columns MaxRentalDuration and MinRentalDuration respectively. 5. List the actor ID, last name, and first name of each actor and the count of films (name column FilmCount) each is in for those actors who acted in more than 35 films. Order results by FilmCount. (Hint: You will need to use GROUP BY and HAVING in your query.)
Write a SQL query that shows the price of each
order made by customers whose last name starts with the
letter M. Display the order number, the last name on the order, and
the price of the order (Order Price). Show the results with the
highest order price first.
Write a SQL query that determines the most
expensive item purchased in each order (Item Price). Display the
order number, the date of the order, the last name of the customer...
can someone solve these quick
please and thank you!
sql chapter 4
Query #1: List the company name, contact name, contact title and
the phone number for customers who HAVE NOT put in an order. Use an
outer join.
Query #2: Create a listing displaying the employee first name,
last name and the full name (First name space Last Name) of the
person they report to (Supervisor). This is a self-join. If an
employee does not report to anyone then...
Create an SQL Query to show
how many customers there are in each state.
Sample results
ST CUST_COUNT
-- ----------
CA 1
GA 1
CO 2
DC 1
WA 4
BC 1
CUSTOMER CustomerlD ARTIST TRANS WORK SArtistID LastName PURCHASES/SOLD TO Q TransactionID ACQUIRED OworkID CREATES/CREATEDBY FirstName AreaCode LocalNumber Street City State ZipPostalCode Country Email (AK1.1) DateAcquired AcquisitionPrice DateSold SalesPrice AskingPrice WorkID (FK) CustomerlD (FK) Title (AK1.1) o- Copy (AK1.2) Medium Description ArtistID (FK) LastName (AK1.1) FirstName (AK1.1) Nationality DateOfBirth...
Need the SQL query for the questions below
1) Print the name of customers who do not live
in MPLS or Edina, have a loan with an amount of more than 500 in
any branch of the bank but not in the France branch, and have one
or more accounts only in the France branch.
2) Show the name of all Customers who have only
one account with a balance of more than $1000 in any branch of the
bank...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago