contestada

enter your entire script below. do not include statements to drop objects as your script will be executed against a clean schema. you may include select statements in sub queries in your insert statements, but do not include select queries that return records for display. continue to use the purchase61 and purchaseitem61 tables that you created and modified in the previous problems. increase the shippping cost of every purchase from manufacturers in massachusetts ('ma') by 10%. round your calculations to two decimal points. hint: use the in clause. do not use a join.

Respuesta :

Ayush603

How to increase cost?

To increase the shipping cost of every purchase from manufacturers in Massachusetts by 10%, you can use the Above update statement

How to UPDATE?

This statement will update the shipping_cost column in the purchase61 table for every purchase where the manufacturer is in the list of manufacturers in Massachusetts, as determined by the subquery. The shipping cost will be increased by 10% by multiplying it by 1.10.

Note that you should round the calculations to two decimal points by using the ROUND function. You could modify the statement as follows:

UPDATE purchase61

SET shipping_cost = shipping_cost * 1.10

WHERE manufacturer IN (SELECT manufacturer FROM purchaseitem61 WHERE state = 'MA')

To Learn More About SQL, Check Out

https://brainly.com/question/13068613

#SPJ1

Otras preguntas