Create the stored procedure

Report a typo

We have a table named customers with id, name, address, and city columns:

ID Name Address City
1 John Doe 235 McDonald Ave. Los Angeles
2 Adam Davis 4756 Central Str. New York
3 Jessica White 345 Briercliff Road Los Angeles
4 Nick Smith 45 Confedence Center Washington D.C
5 Kim Archer 67 Scenic Way Los Angeles

Your goal is to create stored procedure named LosAngelesCitizens that will select all customers from Los Angeles , and then execute it.

Write an SQL statement





___

Create a free account to access the full topic