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.
