Question: Books(bid:integer, bname:string, author:string, year:integer, price:integer)Orders(cid:integer, bid:integer, quantity:integer)Customers(cid:integer, cname:string, zipcode:string) The meaning of attributes is as follows:bid: book unique identifier, bname: book name; author, year and

Books(bid:integer, bname:string, author:string, year:integer, price:integer)Orders(cid:integer, bid:integer, quantity:integer)Customers(cid:integer, cname:string, zipcode:string) The meaning of attributes is as follows:bid: book unique identifier, bname: book name; author, year and price (per unit) are self-explanatoryquantity: number of books purchased with an ordercid: unique customer identifier, cname: customer name, zipcode: customer address zipcode.Write SQL queries for the following:

(a)Find distinct authors of books ordered in quantities of at least 50 from zi pcode 02125.

(b)Find the names of customers who ordered only books with pri ce l owe r than $100.

(c)Find the average price of ordered books for each customer (listed as cid) who bought at least 20 different book titles costing at least $20 each.

(d)Find the names of customers who ordered every book written by Edgar Codd.

(e)Find the author name(s) of the best-selling book(s) (meaning the books that sold the hi ghest number of copies).

( f)[630 onl y] Find the name(s) of most valuable customer( s), i.e. those who spent the most money.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You are given the following relational schema. Books (bid:integer, bname:string, author:string, year:integer, price:integer) Orders (cid:integer, bid:integer, quantity:integer) Customers...

Question You are given the following database: Books ( bid:integer, bname:string, author:string, year:integer, price:integer ) Orders ( cid:integer, bid:integer, quantity:integer ) Customers (...

Write the SQL statement that extracts the name and author of books that were published in 2020. Order the result by the name of the book in ascending order. Write the SQL statement that extracts...

Name three problems associated with carrying too little inventory.

A letter to your debt-ridden client on the outstanding dues owed to your company

International data show a positive correlation between political stability and economic growth. a. Through what mechanism could political stability lead to strong economic growth? b. Through what...

The budgets of four companies yield the following information: Company Requirements 1. Fill in the blanks for each company. 2. Compute breakeven, in sales dollars for each company. Which company has...

Books(bid:integer, bname:string, author:string, year:integer, price:integer)Orders(cid:integer, bid:integer, quantity:integer)Customers(cid:integer, cname:string, zipcode:string) The meaning of...

This problem requires the calculation of posterior probabilities. Dawsons is a fruit and vegetable stand in southern New Jersey that is considering an expansion of the facility to take advantage of...

1. What concepts from the chapter are illustrated in these videos? Explain your answer. 2. What ethical issues are illustrated in these videos? Explain your answer. 3. How else might you handle this...

Index funds typically have turnover than actively managed funds, which makes them typically tax efficient higher; more higher; less lower; less lower; more

According to Henry Ford, the goal of an organization's vision should be to ______. Multiple choice question. provide a needed product or service just increase the profit it earns charge an...

2. Answer the following questions, which relate to measures of concentration: LO14.1 a. What is the meaning of a four-firm concentration ratio of 60 percent? 90 percent? What are the shortcomings of...

3. Explain the general meaning of the profit payoff matrix below for oligopolists X and Y. All profit figures are in thousands. LO14.2 a. Use the payoff matrix to explain the mutual interdependence...

1. Suppose that a small town has seven burger shops whose respective shares of the local hamburger market are (as percentages of all hamburgers sold): 23 percent, 22 percent, 18 percent, 12 percent,...