Dear friends, I have some SQL problems to turn in, help will be appriciated. 14. Code an SQL SELECT statement which lists the itemName, itemDescription and highest bid amount for each auction_item. 15. Rewrite your query above to include auction_items for which there is no bid 16. Code an SQL SELECT statement which lists the bidder_username, bidder's email , itemID, itemName and amount for each bid. Sort the output by bidder_username in reverse alphabetic order. 17. Rewrite your query above to include all members, whether or not they have placed a bid Database diagram as follows(connected eachother with the key): AUCTION_ITEM BID KEY: itemID KEY:itemID seller_username Key:bidSeqNo itemName bidder_username itemDescription bidDateTime categoryName amount startDate endDate ACTION_CATEGORY MEMBER kEY:CategoryName kEY: username CategoryDescription email joinDate suspendedDate Last edited: 12-Mar-10 09:34 PM
Npl_US · Mar 12, 2010 9:21 PM · 306 views
talai laaz saaz chaina yesari homework public website ma post garna..Yeti jabo homework pani garnaa nasakne taa hasto hutiyaara chullu bhar paani ma dubera kina mardainas
mampakha · Mar 12, 2010 10:06 PM
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New Discussion