Question: Create an un - named Block in SQL with the following criteria: Variables constant named REVIEW _ ID assigned to any value between 1 1
Create an unnamed Block in SQL with the following criteria:
Variables
constant named REVIEWID assigned to any value between
a variable named greeting that is of the appropriate data type and is assigned
to the value Greeting!
A variable named reviewer that is of the appropriate data type initialized to an
empty string
In the Begin block, create a Select statement that retrieves a ReviewerName from the
REVIEWS table that is assigned to the value stored in the constant variable.
Display the output that concatenates the greeting variable with the reviewer variable. Column names in REVIEWS table:
REVIEWERID
ASIN
REVIEWERNAME
HELPFUL
REVIEWTEXT
OVERALL
SUMMARY
REVIEWTIME
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
