Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
1) Display the Name of the Product and the corresponding name of the supplier of that Product.
(Hint: Products and Suppliers table)
2) Write a query to display the name of the product and the quantity of the Orders of that product. It is OK to display the product name multiple times if the product has been ordered multiple times (i.e., don’t have to use GROUP BY)
3) Write a query to display the Shipper’s name and Order Date when the order was placed. It is OK to display the Shipper’s name multiple times if the order is placed more than once using the shipper.
Please let me know how the SQL quereys would look like using TABLE JOINING only.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Select the best answer from the given choices: Queries can be used within statement(s): update delete All of the answers Insertarrow_forwardTask 11: Find the ID, first name, and last name of each customer whose first name begins with the letter S.arrow_forwardCreate a query to show the subject and the quantity of books in each category. Sort the results in ascending order by the number of books, then in ascending order by the subject name.arrow_forward
- Please help, I know it's hard but no one else is willing to try and I am lost and spent three days on this so far. Write a query to display the author ID, first and last name for all authors who have ever written a book with the subject Programming. Sort the results by author's last name (Figure P7.106). In the SQL Query do the following Select clause: Display the columns stated in the problem statement From clause: AUTHOR table Where clause: authors who have ever written a book with the subject Programming. (Hint: Subquery) Order by clause: Sort the results by author last namearrow_forwardhow is duplicate column prefixed when duplicate column appear in Join Query? a) Table name followed by period b) Table name followed by plus c) Table name followed by equal d) Table name followed by space abd then column namearrow_forwardWrite a query to list the author last name, author first name and the book title and cost for each book written by the author “Xia Chiang”. Sort the result by the book title and then the costdescendingarrow_forward
- Task 2: List the owner number and last name for all owners located in the city of Seattle. Your query should ignore case. For example, a customer with the city Seattle should be included, as should customers whose city is SEATTLE, SEAttle, SeAttle, and so on.arrow_forwardWrite a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.arrow_forwardWrite a query to list the book title, checkout date, checkout due date and checkout in date for each book.arrow_forward
- 4) Display the firstname, lastname of the employees and the customerID that the employee served. Arrange the results by the last name. 5) Write a query to the Name of the Product and the corresponding name of the supplier of that Product for all the products that start with a “P”. 6) Write a SQL query to output the product name and the quantity of the Orders of that product for those orders with more than 70 quantity. (hint: don’t have to use GROUP BY) I need help figuring out the SQL quereys for the questions above using table joining methodarrow_forwardIf a subquery is used in the FROM clause of a query, how are the subquery’s results referenced in other clauses of the query?arrow_forwardWrite a query that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in CUSTOMER table, call this CUSTOMER_NAME), Phone number of ALL Customers (based on CUS_AREACODE and CUS_PHONE in CUSTOMER table, call this CUSTOMER_PHONE), for those haven’t flied before (based on the record in CHARTER table).arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education