Im trying to get some Queries done and I having issues and n

I\'m trying to get some Queries done, and I having issues and need some help my database image is below:

Summary 1:

Detail View:

Database Image:

l. Write an SQL SELECT statement to select all of your Seller\' clients. Include the client\'s first name, last name screen name, street address, city, state and zip code in your query. Clients that are both Buyers and Sellers may be included in this query, but clients that are only Buyers should not be included. 2. 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. 3. Write an SQL SELECT statement to display the information shown on the screen shot on page 4 of Part 1 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 4. Write an SQL UPDATE\' statement to change one of your Seller clients to a Buyer/Seller type client 5. 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 6. 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

Solution

1) As per the given database description , whatever information firstname, lastname, screenname, streetaddress, city , zipcode all are present under CLIENT table and then it says client type could be buyers or seller but not only buyers so a client id would be present in both BUYERS and SELLER table to fulfull this condtion

Select CLIENT_FNAME,CLIENT_LNAME,CLIENT_SCREENNAME,CLIENT_ADDRESS1,CLIENT_CITY,CLIENT_STATE,CLIENT_ZIPCODE from CLIENT where CLIENT_TYPE IN(\'BUYERS\', \'SELLERS\') and SELLER.CLIENT_ID = BUYERS.CLIENT_ID