My Question is :
USING WHEN-SELECT STATEMENTS,how can we define a new variable providing the country of origin for each model based on the manufacturer .??
what should be the code ?
Just simple assignments in each when/otherwise clause.
The syntax, check out yourself in the documentation.