Question: Write an SQL statement that would: ( a ) Output outfit name, price and origin for all shirts and trousers that cost more than kshs

Write an SQL statement that would:
(a) Output outfit name, price and origin for all shirts and trousers that cost more than kshs.550 alphabetically by name.
(b) Due to economic problems, the price of trousers has tripled. Write an SQL statement to effect the increase.
(c) Write an SQL statement that returns a relation where the colour of the outfit is blue or the price is more than or equal to kshs.1,200.
(d) Write an SQL statement to delete the record for the outfit Savco trouser from the table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

x