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...
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...
This assignment consists of a series of SQL questions. For each question, you will need to...
This assignment consists of a series of SQL questions. For each
question, you will need to include:
• SQL query.
• An explanation of the query. Please include explanations as a
comment AFTER your query, e.g., enclosed within a /* comments block
*/ ). See the first example in the SQL tutorial for a comment. You
don’t need to explain straightforward code in comments. Only the
parts that are interesting or different, so that we understand what
you did.
Question-1...
I am trying to solve two SQL questions: 1. Display each movie’s title and total gross,...
I am trying to solve two SQL questions: 1. Display each movie’s title and total gross, where total gross is USA gross and worldwide gross combined. Exclude any movies that do not have values for either USA gross or worldwide gross. Show the highest grossing movies first. 2. Display the number of movies with an MPAA rating of G, PG, PG-13, and R. Show the results in alphabetical order by MPAA rating.
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...
This assignment consists of a series of SQL questions. For each
question, you will need to include:
• SQL query.
• An explanation of the query. Please include explanations as a
comment AFTER your query, e.g., enclosed within a /* comments block
*/ ). See the first example in the SQL tutorial for a comment. You
don’t need to explain straightforward code in comments. Only the
parts that are interesting or different, so that we understand what
you did.
Question-1...
Most questions answered within 3 hours.
-
which of the following is not a category of project management
risk?
a) external
b) internal...
asked 2 minutes ago -
Focus on Critical Thinking: Are citizen suit provisions an
effective way to achieve environmental objectives? Do...
asked 34 minutes ago -
Gaseous butane CH3CH22CH3 will react with gaseous oxygen O2 to
produce gaseous carbon dioxide CO2 and...
asked 59 minutes ago -
Required to construct counters using synchronous sequential
logic. Use one hex digit to display the result....
asked 1 hour ago -
(Ultra) Large-Scale Systems –Characteristics?
explain in detail
How the nature of an enterprise affect complex...
asked 1 hour ago -
Some of the antibiotic susceptible strains show colonies within
the clear zone. What it does this...
asked 1 hour ago -
In the lottery game Fantasy 5 you have to select 5 numbers from
the numbers {1,2,3,.......,38,39}....
asked 1 hour ago -
A call option on Jupiter Motors stock with an exercise price of
$80 and one-year expiration...
asked 1 hour ago -
What is the disadvantage of an automated vulnerability scan tool
like Nessus?
prone to false negatives...
asked 1 hour ago -
An Atwood’s machine has m1 = 0.105 kg, m2 = 0.100 kg, hung from
a 5.00...
asked 1 hour ago -
A firm is considering a project that has the following estimated
cashflows:
Increased sales to business...
asked 1 hour ago -
Programming logic C# visual studio
What are the values of the double variable x after each...
asked 1 hour ago