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. List the customers living in Georgia or Florida who have recently placed an order totalling more than $80.


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