ai pas conducts wutins twice a year, Gioen the followine datahase on their aucti

Question

ai pas conducts wutins twice a year, Gioen the followine datahase on their auctions (primary keys END-DATE 15-OCT-14 SPRING 2015 15-FEB-15 22-FEB-19 AMOUNT-RAISED 125,879 89,325 AUCTION-ID- TITLE FALL 2014 START DATE I til - A001 A002 ITEM TEM-ID CATEGORY IT001 IT002 TITLE DAISIES DONOR SALE-PRICE 3,700 1,589 AUCTION-ID A. VAN GOGH A001 PAINTING CERAMIC PORTLAND VASE A002 JOSIAH WEDGWO0D BID BID-ID BIDDER B001 AMOUNTITEM-ID T001 BID-DATE BID-TIME 12:45 2,500 a] List all attributes of auctions held wholly in 2014. [b] List all items (category, title, donor, and sale price) for paintings that sold for more than $2500 [c] List all bids for the Portland vase donated by Josiah Wedgwood. (15 points)

Explanation / Answer

1.SELECT * FROM AUCTION WHERE START-DATE LIKE '%14';

2.SELECT CATEGORY TITLE DONOR SALE-PRICE FROM ITEM WHERE SALE-PRICE>2500 AND CATEGORY=PAINTING;

3.SELECT BID-ID BIDDER BID-DATE BID-TIME AMOUNT ITEM-ID WHERE DONOR=JOSIAH WEDGWOOD AND TITLE = PORTLAND VASE
FROM ITEM FULL OUTER JOIN BID ON ITEM.ITEM-ID = BID.ITEM-ID;

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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