Can someone help me with some SQL queries? Write an SQL SELECT statement to disp

Question

Can someone help me with some SQL queries?

Write an SQL SELECT statement to display the information shown on the screen shot on page 3 of Part 1 of the Project for the items for Purchase', 'Buy-It-Now' item, "Summary View 1" for sale by 'Keegan Styles' you created for step 2d above. Include all the fields shown on the screen shot except for images, buttons and payment types accepted. Note that you must include the screen name of the seller not the seller's ID number. This will require a 'join' of tables in your database. Write an SQL SELECT statement to display the information shown on the screen shot on page 4 of Part I of the Project for the items for Purchase', Bid Option' item, "Detail View 2" for sale by 'Keegan Styles' you created for step 2c above Include all the fields shown on the screen shot except for images, buttons and payment types accepted. Note that you must include the screen name of the seller not the seller's ID number. This will require a 'join' of tables in your database Write an SQL 'UPDATE' statement to change one of your Seller clients to a Buyer/Seller type client. Write an SQL SELECT statement to list all the items on 'Melinda Blackwells' item wish list Include the title or short description of the item, the current price of the item, the start and end dates for the item and the name of the seller. Note that this will require a join of the tables containing the name of the seller, the item for sale and the watch list information. You may use Melinda Blackwell's client number in the query. Write an SQL SELECT statement to select both of the feedback records created for step 2g above. Select the screen names of the buyer and seller, the type of feedback (left by seller or by buyer), the feedback comments and the positive/negative value of the rating along with the title or short description of the item purchased. This will require a join of the feedback table, the client table(s) and the item table You may use the item number in your query. Items may be offered as 'Buy It Now' or may be up for 'Bid' Sellers may sell many items and each item is sold by a single seller Buyers may bid on or purchase many items Each item purchased is considered a single sale, Each item is sold by one seller and purchased by one buyer. Data requirements include the values on the 4 screen shots shown below and include the following values: ID number of the seller. Item ID, Title or short description of the item. Current Price, Buy-it-now or Auction Setting, Shippin Cost, auction end date and time Items offered as 'Buy It Now' option: specific attributes Number currently sold. Number currently available (Note each 'Buy It Now' listing can include multiple copies of the same item. Each item has its own Condition (New, Used, Not Specified, NWOT implies

Explanation / Answer

4)update tablename columnname set cloumnname="updating value" like column name = column name

update seller mobilecol set mobilemodel="iphone6s" like mobiletype ='apple'

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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