SQL Problems

Archived from the original Sajha.com — preserved as posted, replies can no longer be added here.
Start a New Discussion
Archived Post

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

1 Reply

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