Databases MySQL HW

Background info

Question:

List the itemID, title, category and description for any items whose auction is still active (the auctions end date has not yet passed). Also include the highest-received bid amount for the item. (If no bids on the item have been received yet, list the current bid as NULL.) Tip: In MySQL, use the function now() in your query to represent the current date and time. This can be compared with other DATETIME values using our standard comparison operators ( Auction database. In the database schema described below, the primary key for each relation is the set of underlined attributes shown. Users (userNum, email, name, address, phone) Items (itemID, seller Num, category, title, description, startPrice, startDate, endDate) Bids (itemID, buyerNum, bid Time, amount) Feedback (itemID, sellerNum, buyerNum, date, rating, comment) Many relations and attributes in the schema above are self-explanatory, but we provide the following clarifications. The seller Num attribute in the Items and Feedback relations and the buyerNum attribute in the Bids and Feedback relations reference the user Num attribute in the Users relation. In the Bids and Feedback relations, the attribute itemID references the itemID attribute in Items. The startDate and endDate attributes in the Items relation, and the bid Time attribute in the Bids relation are defined as values of the type DATETIME in mySQL. In the Feedback relation, the rating attribute is an integer ranging from 1 to 5, inclusive, where higher values are more positive. The comment attribute is an open-ended text field