Please turn this join statement into a Sub-query. Select avg(baseball.sellingprice) as AverageSellingPrice, Suppliers.SupplierName From baseball, Suppliers...

Question

Question

Please turn this join statement into a Sub-query. Select avg(baseball.sellingprice) as AverageSellingPrice, Suppliers.SupplierName From baseball, Suppliers...

Please turn this join statement into a Sub-query.

Select avg(baseball.sellingprice) as AverageSellingPrice, Suppliers.SupplierName

From baseball, Suppliers where baseball.suppliercode = suppliers.suppliercode

group by Suppliers.suppliername

Having suppliers.suppliername = "logo goods";

Thank you

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Select avg(baseball.sellingprice) as AverageSellingPrice, Suppliers.SupplierName
From baseball, Suppliers
where baseball.suppliercode IN
( Select suppliercode From Suppliers
group by suppliername
Having suppliername = "logo goods");

Add a comment

Answer 2

Similar Homework Help Questions

Rewrite the following SQL query using a sub query: SELECT Shares.shareName, Shares.code FROM Nations INNER JOIN...

Rewrite the following SQL query using a sub query: SELECT Shares.shareName, Shares.code FROM Nations INNER JOIN Shares ON Nations.ID = Shares.nationID WHERE Nations.nationName = 'Australia';
I have this answer: SELECT c.Code, count(*) FROM country c JOIN countrylanguage cl ON c.Code =...

I have this answer: SELECT c.Code, count(*) FROM country c JOIN countrylanguage cl ON c.Code = cl.CountryCode GROUP BY cl.CountryCode HAVING COUNT(*) > 1 LIMIT 10; From a previous question I asked which was: Using the database you installed from the link below, provide an example query using both a group by clause and a having clause. Show no more than ten rows of your query result. Discuss if the query you wrote can be rewritten without those clauses. The...
I have this answer: SELECT c.Code, count(*) FROM country c JOIN countrylanguage cl ON c.Code = cl.CountryCode GROUP BY c...

I have this answer: SELECT c.Code, count(*) FROM country c JOIN countrylanguage cl ON c.Code = cl.CountryCode GROUP BY cl.CountryCode HAVING COUNT(*) > 1 LIMIT 10; From a previous question I asked which was: Using the database you installed from the link below, provide an example query using both a group by clause and a having clause. Show no more than ten rows of your query result. Discuss if the query you wrote can be rewritten without those clauses. The...

1. Select the correctly written query. SELECT ALL FROM CUSTOMERS WHERE 10243 IS CUSTOMERID PULL *...

1. Select the correctly written query. SELECT ALL FROM CUSTOMERS WHERE 10243 IS CUSTOMERID PULL * FROM CUSTOMERS WHERE CUSTOMERID = 10243 GET LIST FROM CUSTOMERS SELECT * FROM CUSTOMERS WHERE CUSTOMERID = 10243 2. The GROUP BY clause can be used in place of a JOIN clause in a SQL query? True False 3. The number of join conditions is always equal to the number of tables being joined _____ one. Plus Divided by Times Minus
Transcribe the following SQL queries into an equivalent relational algebra expression. 1. SELECT s_number , AVG(...

Transcribe the following SQL queries into an equivalent relational algebra expression. 1. SELECT s_number , AVG( grade ) FROM grades GROUP BY s_number HAVING AVG( grade ) > 5 . 5 ; 2. SELECT SUM( volume ) FROM fertilizer_applications LEFT JOIN crop_field ON fertilizer_applications . crop_field_id = crop_field . id GROUP BY field_number HAVING field_number = 3 ;
How to write this query in Formal Relational Query Languages? SELECT M.Name, M.Email FROM Manager AS...

How to write this query in Formal Relational Query Languages? SELECT M.Name, M.Email FROM Manager AS M, ManagerCertificate AS MC WHERE M.ID = MC.ManagerID GROUP BY M.Name HAVING count distinct (MC.CertificateID) = 2;

What is wrong with the following query? select firstname , lastname from Customer intersect select productid...

What is wrong with the following query? select firstname , lastname from Customer intersect select productid , price , quantity from order_detail join orders on order_detail.orderid = orders.orderid; Group of answer choices 1 Nothing is wrong with this query 2 When working with set operators both queries have to contain the same number of columns. 3 The wrong set operator is being used. This query should use EXCEPT. 4 The wrong set operator is being used. This query should use...
gender) in HDFS, write a MapReduce Given a 10TB table Student (name, year, program to compute the following query. gpa, SELECTyear, AVG (gpa) FROM WHERE GROUP BY year Student gender'Male' Ans...

gender) in HDFS, write a MapReduce Given a 10TB table Student (name, year, program to compute the following query. gpa, SELECTyear, AVG (gpa) FROM WHERE GROUP BY year Student gender'Male' Answer gender) in HDFS, write a MapReduce Given a 10TB table Student (name, year, program to compute the following query. gpa, SELECTyear, AVG (gpa) FROM WHERE GROUP BY year Student gender'Male' Answer
consider the following relational database that records details of parts and suppliers. Primary keys are underlined...

consider the following relational database that records details of parts and suppliers. Primary keys are underlined and the Foreign Keys are identified with (FK). Suppliers (sid, sname, address, credit) Parts (pid, pname, color) Catalog (sid (FK), pid (FK), cost) The credit attribute denotes the size of the supplier’s credit account. The Catalog relation lists the prices charged for parts by Suppliers. Which of the following queries returns the snames of suppliers who supply every part? Select one or more: a....

1 - Which of the following allows you to create subtotals in the output from a...

1 - Which of the following allows you to create subtotals in the output from a SELECT statement? Group of answer choices _ SUBTOTAL _ ORDER BY _ HAVING _ GROUP BY 2 - A query includes grouping done using the AVG, SUM, COUNT, MIN, or MAX function. Which SQL keyword is used to select rows after this grouping has been done? Group of answer choices _ WHERE _ DISTINCT _ HAVING _ LIKE 3 - Which of the following...

Please turn this join statement into a Sub-query. Select avg(baseball.sellingprice) as AverageSellingPrice, Suppliers.SupplierName From baseball, Suppliers...

Homework Answers

Add Answer to:
Please turn this join statement into a Sub-query. Select avg(baseball.sellingprice) as AverageSellingPrice, Suppliers.SupplierName From baseball, Suppliers...

Post as a guest

Earn Coins

Rewrite the following SQL query using a sub query: SELECT Shares.shareName, Shares.code FROM Nations INNER JOIN...

I have this answer: SELECT c.Code, count(*) FROM country c JOIN countrylanguage cl ON c.Code =...

I have this answer: SELECT c.Code, count(*) FROM country c JOIN countrylanguage cl ON c.Code = cl.CountryCode GROUP BY c...

1. Select the correctly written query. SELECT ALL FROM CUSTOMERS WHERE 10243 IS CUSTOMERID PULL *...

Transcribe the following SQL queries into an equivalent relational algebra expression. 1. SELECT s_number , AVG(...

How to write this query in Formal Relational Query Languages? SELECT M.Name, M.Email FROM Manager AS...

What is wrong with the following query? select firstname , lastname from Customer intersect select productid...

gender) in HDFS, write a MapReduce Given a 10TB table Student (name, year, program to compute the following query. gpa, SELECTyear, AVG (gpa) FROM WHERE GROUP BY year Student gender'Male' Ans...

consider the following relational database that records details of parts and suppliers. Primary keys are underlined...

1 - Which of the following allows you to create subtotals in the output from a...

Please turn this join statement into a Sub-query. Select avg(baseball.sellingprice) as AverageSellingPrice, Suppliers.SupplierName From baseball, Suppliers...

Homework Answers

Add Answer to: Please turn this join statement into a Sub-query. Select avg(baseball.sellingprice) as AverageSellingPrice, Suppliers.SupplierName From baseball, Suppliers...

Post as a guest

Earn Coins

Add Answer to:
Please turn this join statement into a Sub-query. Select avg(baseball.sellingprice) as AverageSellingPrice, Suppliers.SupplierName From baseball, Suppliers...