using SQL: Find out the number of publishers in each city (alias: numpubs). display also the...
Homework Answers
The AQL query to display the number of publishers in each city will be as below:-
SELECT PubName, city
FROM Publishers
The above SQL will provide the result of the publisher names from various cities
Add Answer to:
using SQL:
Find out the number of publishers in each city (alias:
numpubs). display also the...
Please answer each question using these tables above, it is SQL Display the descriptions and prices of the 5 most expe...
Please answer each question using these tables above, it is
SQL
Display the descriptions and prices of the 5 most expensive
parts, in descending order by price.
For each part, display the On Hand Value, which is calculated
by multiplying the quantity on hand by price.
Display a summary with part number, description, on hand and
warehouse for all parts in class HW or AP, and in warehouse 1 or
2.
Display the names of customers who do NOT live...
Currently working in SQL For each manufacturerID, what is the least expensive product price? Display the...
Currently working in SQL
For each manufacturerID, what is the least expensive product
price? Display the manufacturerID as well as a column with the
alias LeastExpensiveShoe. Sort the results from least
expensive to most expensive. This query does not require the
JOIN clause.
Product ProductID ProductName ManufacturerlD Category Color Price Description Manufacturer ManufacturerID ManufacturerName Address City State PostalCode Phone
There are 7 problems that require using joins. Each problem has 10 points. 1. Write an...
There are 7 problems that require using joins. Each problem has 10 points. 1. Write an SQL command that will find any customers who have not placed orders and sort them out by CustomerID in ascending order. 2. List the employees and supervisors names for each supervisor who supervises more than two employees. 3. List the name of each employee, his or her birth date, the name of his or her manager, and the manager’s birth date for those employees...
if you do not have the world schema you can obtain the scripts to create the...
if you do not have the world schema you can obtain the scripts to create the database schema from https://dev.mysql.com/doc/index-other.html Queries Write a SQL query that shows all the columns in the country table for the North America region. The results need to be sorted in ascending order by population. Write a SQL query that shows the unique regions in the country table except for the regions from the continent of Oceania. The results need to be sorted in ascending...
need a solution/explanation for this SQL problem. 7. Display a list of customer names with furniture series that purchased more than twice by this customer. Also, display the number of times of purcha...
need a solution/explanation for this SQL problem. 7. Display a list of customer names with furniture series that purchased more than twice by this customer. Also, display the number of times of purchase. 8. Display a list of furniture series that are priced above the average of all other series. 9. Display the customer ID of the the customers, the series and price of the most expensive furniture they purchased. Sort the result by customer ID in ascending order CUSTOMER...
Please refer to the following business scenarios: (i) Using SELECT statements of SQL, find the employee...
Please refer to the following business scenarios:
(i) Using SELECT statements of SQL, find the employee id, first
name, last name, job title and email of all employees working in
Asia (i.e. all countries coming from the region
‘Asia’). This query must be implemented
as a nested query!
(ii) Using SELECT statements of SQL, find the employee id, first
name, last name, job title and supervisor id of employees who had
worked for more than 3 years and completed...
Which SQL statement retrieves the EmployeeName and City columns from the Employees table? O LIST EmployeeName,...
Which SQL statement retrieves the EmployeeName and City columns from the Employees table? O LIST EmployeeName, City ON Employees; O FIND EmployeeName, City ON Employees; SELECT EmployeeName, City FROM Employees; O RETRIEVE EmployeeName, City FROM Employees; Which SQL statement finds the different cities in which national parks reside with no duplicate rows listed? SELECT DISTINCT city FROM natlpark ORDER BY city; O ORDER BY natlpark DISTINCT city; O ORDER BY city FROM natlpark; O SELECT city FROM natlpark ORDER BY...
In PL/SQL, With a single query, display the average number of days that each part spent in transit. Round the answers to...
In PL/SQL, With a single query, display the average number of days that each part spent in transit. Round the answers to a whole day the columns are ( PartNo, Shipdate, ArriveDate)
Write just one SQL statement per question 1. Display Publisher ID, Publisher Name and Total Number...
Write just one SQL statement per question 1. Display Publisher ID, Publisher Name and Total Number of Books published by each publisher. 2. List Publisher ID, Publisher Name, Title and price of the highest priced book. 3. List Order ID, Customer ID, Order Date, and Number of Items in each order. Order the data by Customer ID in ascending (A – Z) order. 4. Display Title, Category and Profit for each book in the children and computer category. 5. Display...
Express the following queries in SQL. Only standard SQL syntax is allowed. Each query should be...
Express the following queries in SQL. Only standard SQL syntax is allowed. Each query should be answered in a single SQL statement: 1. Find the name of suppliers that are located in Mumbai. 2. Find the name of suppliers and the names of parts they sell. List the result in descending order suppliers name. 3. Find the names of parts that are sold by exactly two suppliers. 4. Find the names of parts that are sold by all suppliers. 5....
Please answer each question using these tables above, it is
SQL
Display the descriptions and prices of the 5 most expensive
parts, in descending order by price.
For each part, display the On Hand Value, which is calculated
by multiplying the quantity on hand by price.
Display a summary with part number, description, on hand and
warehouse for all parts in class HW or AP, and in warehouse 1 or
2.
Display the names of customers who do NOT live...
Currently working in SQL
For each manufacturerID, what is the least expensive product
price? Display the manufacturerID as well as a column with the
alias LeastExpensiveShoe. Sort the results from least
expensive to most expensive. This query does not require the
JOIN clause.
Product ProductID ProductName ManufacturerlD Category Color Price Description Manufacturer ManufacturerID ManufacturerName Address City State PostalCode Phone
Please refer to the following business scenarios:
(i) Using SELECT statements of SQL, find the employee id, first
name, last name, job title and email of all employees working in
Asia (i.e. all countries coming from the region
‘Asia’). This query must be implemented
as a nested query!
(ii) Using SELECT statements of SQL, find the employee id, first
name, last name, job title and supervisor id of employees who had
worked for more than 3 years and completed...
Which SQL statement retrieves the EmployeeName and City columns from the Employees table? O LIST EmployeeName, City ON Employees; O FIND EmployeeName, City ON Employees; SELECT EmployeeName, City FROM Employees; O RETRIEVE EmployeeName, City FROM Employees; Which SQL statement finds the different cities in which national parks reside with no duplicate rows listed? SELECT DISTINCT city FROM natlpark ORDER BY city; O ORDER BY natlpark DISTINCT city; O ORDER BY city FROM natlpark; O SELECT city FROM natlpark ORDER BY...
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