Question

Using the table
INVENTORY from
CARSHOWROOM
database, write
sql queries for the
following:
a) Convert the CarMake
to uppercase if its
value starts with the
letter ‘B’.
b) If the length of
the car’s model is
greater than 4 then
fetch the substring
starting from position
3 till the end from
attribute Model.

Answer 1

Answer:

ukuktl6il647ll656k73kt47l64k64

Answer 2

Answer:

Photosynthesis is a process by which green plants make their own food....