Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. this requirement can be met by using generic data,

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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

We had an example in class about using a sign test. We are supposed to find...

Statistics
Q

Write VHDL code for ALU 32bit. ALU must perform addition and subtraction. You are not allowed...

Electrical Engineering
Q

What are the characteristics of the EMG? Bandwidth (frequency content)? Magnitude (amplitude)? How will determining the bandwidth...

Electrical Engineering
Q

38 A block of mass m slips on a rough horizontal table under the action...

Physics
Q

Consider the series ?1(a) Does the sequence {an} = 1 converge or diverge?(b) Does this...

Basic Math
Q

Previous You deposit 6000 in an account earning 5 interest compounded continuously How much will...

Algebra
Q

Given the points below that are on the graph of f x 3 identify the...

Algebra
Q

The inventories disclosure note in the 2014 financial statements for SUPERVALU Inc., one of the...

Accounting
Q

CH20 - Homework 6 5 QS 20-25 Recording costs of factory overhead LO P1, P3...

Accounting
Q

I need help with this ASAP! Thank you! Your aunt,...

Accounting
Q

The income statement shown below was sent by Samuel Cox, owner of Cox Video Center,...

Accounting
Q

Cash and equivalents = $3,600 Short-term investments = $4,600 Expenses = $145,000 Depreciation = $5,000...

Finance