I need help writing a SQL query for the following: List the names of all books which have fewer pages than the average number of pages in all books published by Lions Publishing. List the names of all books which have fewer pages than the number of pages in every book published by Lions Publishing. List the names of all books which have fewer pages than the number of pages in at least one book published by Lions Publishing. List all customer information for the customer or customers who paid the least for any book in the store.
I need help writing a SQL query for the following: List the names of all books which have fewer pages than the average number of pages in all books published by Lions Publishing. List the names of all books which have fewer pages than the number of pages in every book published by Lions Publishing. List the names of all books which have fewer pages than the number of pages in at least one book published by Lions Publishing. List all customer information for the customer or customers who paid the least for any book in the store.
Chapter3: Creating Tables
Section: Chapter Questions
Problem 13RQ
Related questions
Question
I need help writing a SQL query for the following:
- List the names of all books which have fewer pages than the average number of pages in all books published by Lions Publishing.
- List the names of all books which have fewer pages than the number of pages in every book published by Lions Publishing.
- List the names of all books which have fewer pages than the number of pages in at least one book published by Lions Publishing.
- List all customer information for the customer or customers who paid the least for any book in the store.
Transcribed Image Text:ВОOK
ВОOKNUM
ВОOKNAME
PUBYEAR
PAGES
PUBNAME
CUSTOMER
CUSTNUM
CUSTNAΕ
ADDRESS
PHONE
SALES
ВОOKNUM
CUSTNUM
DATE
PRICE
PUBLISHER
PUBNAME
ADDRESS
PHONE
Write SQL queries to retrieve the information reguested. These can be captured in a Word document or
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 5 images
Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning