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...


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.


ВОOK<br>ВОOKNUM<br>ВОOKNAME<br>PUBYEAR<br>PAGES<br>PUBNAME<br>CUSTOMER<br>CUSTNUM<br>CUSTNAΕ<br>ADDRESS<br>PHONE<br>SALES<br>ВОOKNUM<br>CUSTNUM<br>DATE<br>PRICE<br>PUBLISHER<br>PUBNAME<br>ADDRESS<br>PHONE<br>Write SQL queries to retrieve the information reguested. These can be captured in a Word document or<br>

Extracted 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

Jun 11, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?