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
Homework Answers
The Query is:
SELECT State AS ST, COUNT(CustomerID) AS CUST_COUNT
FROM CUSTOMER
GROUP BY State;
- This query will return the STATE and number of Customers in that state.
Add Answer to:
Create an SQL Query to show how many customers there are in each state. Sample results ST CUST_C...
Write one DDL statement to add ‘C_999’ as a new constraint in Sales. This constraint ensures that...
Write one DDL statement to add ‘C_999’ as a new constraint in
Sales. This constraint ensures that no sale has a SalesPrice value
higher than AskingPrice value. This statement should only affect
new Artwork WorkID Title Copy Medium Description ArtistID Client
ClientID LastName FirstName Street City State ZipPostalCode Country
AreaCode PhoneNumber Email Sales DateAcquired AcquisitionPrice
AskingPrice DateSold SalesPrice ClientID WorkID rows inserted into
Sales in the future but not existing rows. If constraint ‘C_999’
needs to be deleted from Sales...
Suppose ‘ON UPDATE CASCADE’ is included in a foreign key constraint of AWS. Explain its actual...
Suppose ‘ON UPDATE CASCADE’ is included in a foreign key
constraint of AWS. Explain its actual meaning and implication in
AWS.
Sales DateAcquired AcquisitionPrice AskingPrice DateSold SalesPrice Client ClientID Artwork LastName FirstName Street City State ZipPostalCode Country AreaCode PhoneNumber Email WorkID Title Copy Medium Description ArtistID ClientlD WorkID
The Chinook team would like to throw a promotional Music Festival for their top 10 customers...
The Chinook team would like to
throw a promotional Music Festival for their top 10 customers who
have spent the most in a single invoice. Write a query that returns
the first name, last name, and invoice total for the top 10
invoices ordered by invoice total descending.
MediaType Artist Album Track Artistld Albumld MediaTypeld Trackld Title Name Name Name Artistld Albumld MediaTypeld Genreld Composer Genre Playlist Track Playlist Milliseconds Genreld Playlistld Playlistld Name Bytes Name Trackld UnitPrice InvoiceLine Employee...
Write an SQL query against the Chinook Database v1.4. Each query must run successfully using DB...
Write an SQL query against the Chinook Database v1.4. Each query
must run successfully using DB Browser for SQLite. Create the exact
query below. Must use sub query. I saw that a
similar solution for this question used IF and CONCAT functions
which do not work and return errors. If it is possible to use the
CASE function in place of IF that would be greatly appreciated.
Also I really hate to ask but if it could be organized neatly...
Using the database: Write SQL queries for each of the questions below. 1. Find the media...
Using the database: Write SQL queries for each of the questions
below.
1. Find the media type which
has 100 or more tracks. Print the name of such media type. Number
of rows returned in the result = 3
A) Find the playlists which have one or more tracks that have
never been purchased in California (CA). Print the Id, and the name
of such playlists. Number of rows returned in the result = 18
B) Find the customers who...
Question for SQL in MS SQL Server Management Studio (Please don't use where clause for Joins...
Question for SQL in MS SQL Server Management Studio (Please
don't use where clause for Joins use from clause)
Need to Create a Query to display products purchased by
customers in Germany that were not purchased by customers in the
US.
Customers PK Customer D CompanyName Contact Name Contact Title Address City State OrRegion PostalCode Country Phone char(5) varchar(40) varchar(30) varchar(30) varchar(60) varchar(15) varchar(15) varchar(10) varchar(15) varchar(24) varchar(24) Order Details Orders PK OrderID int FK CustomerlD char(5) FK Employeeld int...
Question for SQL in MS SQL Server Management Studio (Please don't use where clause for Joins...
Question for SQL in MS SQL Server Management Studio (Please
don't use where clause for Joins use from clause)
Need to Create a Query because Northwind Traders wants to make
sure that all orders are shipped within 10 days. Display any orders
that were not shipped within 10 days. Include the OrderID, the
OrderDate, and the number of days it took before the order was
shipped.
Customers PK Customer D CompanyName Contact Name Contact Title Address City State OrRegion PostalCode...
Question for SQL in MS SQL Server Management Studio (Please don't use where clause for Joins...
Question for SQL in MS SQL Server Management Studio (Please
don't use where clause for Joins use from clause)
Need to Create a Query because Northwind Traders has decided to
increase their retail prices. Write a query that shows the product
name, the current price, and the new price. Make sure the new price
is listed to 2 decimal points. Follow below guidelines on new
retail price:
a. If the
category is beverages or dairy products, increase the price by...
Write one DDL statement to add ‘C_999’ as a new constraint in
Sales. This constraint ensures that no sale has a SalesPrice value
higher than AskingPrice value. This statement should only affect
new Artwork WorkID Title Copy Medium Description ArtistID Client
ClientID LastName FirstName Street City State ZipPostalCode Country
AreaCode PhoneNumber Email Sales DateAcquired AcquisitionPrice
AskingPrice DateSold SalesPrice ClientID WorkID rows inserted into
Sales in the future but not existing rows. If constraint ‘C_999’
needs to be deleted from Sales...
Suppose ‘ON UPDATE CASCADE’ is included in a foreign key
constraint of AWS. Explain its actual meaning and implication in
AWS.
Sales DateAcquired AcquisitionPrice AskingPrice DateSold SalesPrice Client ClientID Artwork LastName FirstName Street City State ZipPostalCode Country AreaCode PhoneNumber Email WorkID Title Copy Medium Description ArtistID ClientlD WorkID
The Chinook team would like to
throw a promotional Music Festival for their top 10 customers who
have spent the most in a single invoice. Write a query that returns
the first name, last name, and invoice total for the top 10
invoices ordered by invoice total descending.
MediaType Artist Album Track Artistld Albumld MediaTypeld Trackld Title Name Name Name Artistld Albumld MediaTypeld Genreld Composer Genre Playlist Track Playlist Milliseconds Genreld Playlistld Playlistld Name Bytes Name Trackld UnitPrice InvoiceLine Employee...
Write an SQL query against the Chinook Database v1.4. Each query
must run successfully using DB Browser for SQLite. Create the exact
query below. Must use sub query. I saw that a
similar solution for this question used IF and CONCAT functions
which do not work and return errors. If it is possible to use the
CASE function in place of IF that would be greatly appreciated.
Also I really hate to ask but if it could be organized neatly...
Using the database: Write SQL queries for each of the questions
below.
1. Find the media type which
has 100 or more tracks. Print the name of such media type. Number
of rows returned in the result = 3
A) Find the playlists which have one or more tracks that have
never been purchased in California (CA). Print the Id, and the name
of such playlists. Number of rows returned in the result = 18
B) Find the customers who...
Question for SQL in MS SQL Server Management Studio (Please
don't use where clause for Joins use from clause)
Need to Create a Query to display products purchased by
customers in Germany that were not purchased by customers in the
US.
Customers PK Customer D CompanyName Contact Name Contact Title Address City State OrRegion PostalCode Country Phone char(5) varchar(40) varchar(30) varchar(30) varchar(60) varchar(15) varchar(15) varchar(10) varchar(15) varchar(24) varchar(24) Order Details Orders PK OrderID int FK CustomerlD char(5) FK Employeeld int...
Question for SQL in MS SQL Server Management Studio (Please
don't use where clause for Joins use from clause)
Need to Create a Query because Northwind Traders wants to make
sure that all orders are shipped within 10 days. Display any orders
that were not shipped within 10 days. Include the OrderID, the
OrderDate, and the number of days it took before the order was
shipped.
Customers PK Customer D CompanyName Contact Name Contact Title Address City State OrRegion PostalCode...
Question for SQL in MS SQL Server Management Studio (Please
don't use where clause for Joins use from clause)
Need to Create a Query because Northwind Traders has decided to
increase their retail prices. Write a query that shows the product
name, the current price, and the new price. Make sure the new price
is listed to 2 decimal points. Follow below guidelines on new
retail price:
a. If the
category is beverages or dairy products, increase the price by...
Most questions answered within 3 hours.
-
buffer chosen: phosphate, pH before addition of base 7.21 after
addition of base 8.87
1) What...
asked 39 seconds ago -
Do you think that anyone requesting a sex change operation
should be entitled to receive one...
asked 2 minutes ago -
A firm is considering the purchase of a machine which would
represent an investment of $23...
asked 3 minutes ago -
Flower colour in a plant species is determined by two genes,
gene B and gene P....
asked 6 minutes ago -
findWordCrossIndex(horizontalWord, verticalWord) This function
finds and returns the index in the string "horizontalWord" of the
first...
asked 9 minutes ago -
evaluate the statements below and select those that correctly apply
to the role of PAMPs and...
asked 16 minutes ago -
Congratulations! You have just won the Lottery. The Lottery
Commission informs you that you can choose...
asked 22 minutes ago -
bulk flow (in respiration) moves blood from?
Air in and out of lungs?
air into lungs?...
asked 27 minutes ago -
Which of the following describes a private network?
1. A wide area network (WAN) linking sites...
asked 41 minutes ago -
The purpose of this
lab: Wireshark Intro Lab
is to get students
familiar with the use of...
asked 50 minutes ago -
Question 3
A 50 percent deduction is allowed for amounts paid or incurred for
dues and...
asked 48 minutes ago -
Assuming that the wave speed varies little when sound waves are
traveling through a material that...
asked 1 hour ago