Given the schema, answer the following sql query Customer(accountID, lastName, f

Question

Given the schema, answer the following sql query

Customer(accountID, lastName, firstName, email) CreditCard(cardID,accountNumber,expiration.code,street,city,state,zipcode) ShippingAddress(addressID.street,city,state,zipcode) Registers(accountID,cardID) Has(accountID addressID) ShoppingCart(cartID,dateCreated,accountID) Movie(movieID.title,genra) DVD(movieID,videoFormat,languages,caption,quantity,cost) VideoTape(movielD,format,soundTrack,quantity.cost) Contains(cartID movieID,quantity) Includes(saleID,movieID,quantity) Purchase(saleID.totalCost,dateSold,street,city.state,zipcode,accountNumber,expiration.accountID) Given the schema, answer the following

Explanation / Answer

1- Find the titles of the top two movies without using 'TOP' and Row number.
using limit
SELECT title FROM Movie LIMIT 2;

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.