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 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
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
