This requirement can be met by using generic data, the correct mysql coding of script is...

60.1K

Verified Solution

Question

Programming

This requirement can be met by using generic data, the correctmysql coding of script is more important than the data.
1. Increase all of the listing prices by 5% for all listingsunder $500,000 and 10% for all listings $500,000 and higher. Updatethe listings table with the new prices.
2. Add 30 days to the date expires for all listings. Update thelistings table with the new prices.
3. Add \"Listing updated on [current date].\" to the remarks.Replace [current date] with the current systems date. Do notreplace the remarks currently in the table. Add these remarks tothe remarks already in the table.
4. Return the following information from the listings table fromthe stored procedure to display the information in the new realestate app: address, city, state, zip, updated listing price,updated date expires, and updated remarks.
5. Call and run the stored procedure to make the appropriateupdates and return the proper results.

Answer & Explanation Solved by verified expert

4.3 Ratings (638 Votes)

Following are the Sql Scripts 1 Increase all of the listing prices by 5 for all listings under 500000 and 10 for all listings 500000 and higher Update the listings table with the new prices update LISTING set LISTINGPRICE LISTINGPRICE case when LISTINGPRICE 500000 then LISTINGPRICE5100 when LISTINGPRICE 500000 then LISTINGPRICE10100 else 0 end 2 See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member