Question

Create a VIEW as Restaurants_Backup from your YELP Table

- Create a PARTIAL VIEW of only Restaurants in a single State or City

- Show an Update statement that uses a View ( update restaurants, and change a rating from before to a new value.

Write a stored procedure that gets all of the customers from the customers table on the OM database

Show all field names in your procedure. Provide the following;

1. Your Stored Procedure name.sql

2. Show you calling the stored procedure name

3. Show a screenshot of the output of the procedure being called with the data results

Answer 1

[Having sample data/table definition from the YELP table was expected]

Assuming table definition: YELP (restaurant_id, restaurant_name, rating, restaurant_type, created_on, manager_id, state, city, pincode)

VIEW FOR Restaurants_Backup

CREATE VIEW Restaurants_Backup

AS SELECT * FROM YELP

Partial View for Restaurants in single State

Select * from VIEW Restaurants_Backup

GROUP BY State

Stored Procedure to get all customers from the customers table on the OM database

select customer_id from orders

StoredProcedureName

getCustomersFromOrderManagement.sql

Calling StoredProcedure

EXEC getCustomersFromOrderManagement;

[ there isn't any database information provided to share a screenshot of the sample data].