ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region BOOKAUTHOR AUTHOR ВОOKS...


please use sql to answer the following question and erd had been attach


1.Which books were written by an author with the last name Adams? Perform the search using the author name. (join)


ORDERS<br>Order#<br>Customer#<br>Orderdate<br>Shipdate<br>Shipstreet<br>Shipcity<br>Shipstate<br>Shipzip<br>Shipcost<br>CUSTOMERS<br>Customer#<br>Lastname<br>Firstname<br>Email<br>Address<br>City<br>State<br>Zip<br>Referred<br>Region<br>BOOKAUTHOR AUTHOR<br>ВОOKS<br>AuthorD<br>ISBN<br>ISBN<br>AuthorID<br>Lname<br>Fname<br>ORDERITEMS<br>Title<br>Pubdate<br>PubID<br>Cost<br>Retall<br>Discount<br>Category<br>Order#<br>Item#<br>ISBN<br>Quantity<br>Paideach<br>PUBLISHER<br>PubID<br>Name<br>PROMOTION Contact<br>Gift<br>Minretail<br>Maxretall<br>Phone<br>FIGURE 1-5<br>JustLee Books's table structures after normalization<br>

Extracted text: ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region BOOKAUTHOR AUTHOR ВОOKS AuthorD ISBN ISBN AuthorID Lname Fname ORDERITEMS Title Pubdate PubID Cost Retall Discount Category Order# Item# ISBN Quantity Paideach PUBLISHER PubID Name PROMOTION Contact Gift Minretail Maxretall Phone FIGURE 1-5 JustLee Books's table structures after normalization

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here