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 un-named Block in SQL with the following criteria:
Variables
constant named REVIEW_ID assigned to any value between 1172
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 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 Databases Questions!