MY SQL PLEASE For this lab, complete the following tasks and upload screen shots of your code and the results 1 Create a stored procedure that takes a city name for input (IN) and returns the number of languages spoken there as output (OUT) Test this stored procedure with two cities (such as Canada and France) 2 Create a stored procedure that will take a city name as input (IN) and return either Big , Medium , or Small Return Big if the city has more than 5,000,000 people Return Small if the city has less than 100,000 people Otherwise, return Medium Test your procedure with New York, Cleveland, and Boulder 3 Convert the procedure from part 2 into a stored function In this case, you will pass in the city population You will return the city size level (small, medium, or large) To test this, display the name of all of the cities from New York along with their respective sizes (big, medium, or small) world Tables Columns ID Name CountryCode District Population Indexes Foreign Keys Triggers country Columns Name Continent Region SurfaceArea IndepYear Population LifeExpectancy GNP GNPOld LocalName GovernmentForm HeadofState Capital Code2 Indexes Foreign Keys Triggers countrylanguage Columns CountryCode Language IsOfficial Percentage Indexes Foreign Keys Triggers Views Stored Procedures Functions Administration Schemas For this lab, complete the following tasks and upload screen shots of your code and the results 1 Create a stored procedure that takes a city name for input (IN) and returns the number of languages spoken there as output (OUT) Test this stored procedure with two cities (such as Canada and France) 2 Create a stored procedure that will take a city name as input (IN) and return either Big , Medium , or Small Return Big if the city has more than 5,000,000 people Return Small if the city has less than 100,000 people Otherwise, return Medium Test your procedure with New York, Cleveland, and Boulder 3 Convert the procedure from part 2 into a stored function In this case, you will pass in the city population You will return the city size level (small, medium, or large) To test this, display the name of all of the cities from New York along with their respective sizes (big, medium, or small) world Tables Columns ID Name CountryCode District Population Indexes Foreign Keys Triggers country Columns Name Continent Region SurfaceArea IndepYear Population LifeExpectancy GNP GNPOld LocalName GovernmentForm HeadofState Capital Code2 Indexes Foreign Keys Triggers countrylanguage Columns CountryCode Language IsOfficial Percentage Indexes Foreign Keys Triggers Views Stored Procedures Functions Administration Schemas

Question

MY SQL PLEASE For this lab, complete the following tasks and upload screen shots of your code and the results  1  Create a stored procedure that takes a city name for input (IN) and returns the number of languages spoken there as output (OUT)    Test this stored procedure with two cities (such as Canada and France)  2  Create a stored procedure that will take a city name as input (IN) and return either  Big ,  Medium , or  Small     Return  Big  if the city has more than 5,000,000 people    Return  Small  if the city has less than 100,000 people    Otherwise, return  Medium    Test your procedure with New York, Cleveland, and Boulder  3  Convert the procedure from part 2 into a stored function    In this case, you will pass in the city population    You will return the city size level (small, medium, or large)   To test this, display the name of all of the cities from New York along with their respective sizes (big, medium, or small)  world Tables     Columns   ID   Name   CountryCode   District   Population   Indexes Foreign Keys   Triggers country Columns   Name   Continent   Region   SurfaceArea   IndepYear   Population   LifeExpectancy   GNP   GNPOld   LocalName   GovernmentForm   HeadofState   Capital   Code2 Indexes Foreign Keys Triggers countrylanguage Columns   CountryCode   Language   IsOfficial   Percentage Indexes Foreign Keys Triggers Views Stored Procedures Functions Administration Schemas For this lab, complete the following tasks and upload screen shots of your code and the results  1  Create a stored procedure that takes a city name for input (IN) and returns the number of languages spoken there as output (OUT)    Test this stored procedure with two cities (such as Canada and France)  2  Create a stored procedure that will take a city name as input (IN) and return either  Big ,  Medium , or  Small     Return  Big  if the city has more than 5,000,000 people    Return  Small  if the city has less than 100,000 people    Otherwise, return  Medium    Test your procedure with New York, Cleveland, and Boulder  3  Convert the procedure from part 2 into a stored function    In this case, you will pass in the city population    You will return the city size level (small, medium, or large)   To test this, display the name of all of the cities from New York along with their respective sizes (big, medium, or small)  world Tables     Columns   ID   Name   CountryCode   District   Population   Indexes Foreign Keys   Triggers country Columns   Name   Continent   Region   SurfaceArea   IndepYear   Population   LifeExpectancy   GNP   GNPOld   LocalName   GovernmentForm   HeadofState   Capital   Code2 Indexes Foreign Keys Triggers countrylanguage Columns   CountryCode   Language   IsOfficial   Percentage Indexes Foreign Keys Triggers Views Stored Procedures Functions Administration Schemas

Accepted Answer

The Answer is in the image, click to view ...

Question

MY SQL PLEASE For this lab, complete the following tasks and upload screen shots of your code and the results. 1. Create a stored procedure

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Winning Compliance Auditing With Gung Fu Fighting Philosophy

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question