SQL

Here is the info from previous assignment:

Team	Year Founded	Owner	Leader	City	Stadium
Colorado Rockies	1993	Charles Monfort	Bud Black	Denver	Coors Field
Colorado Avalanche	1995	Ann Walton Kroenke	Jared Bednar	Denver	Pepsi Center
Boston Bruins	1924	Jeremy Jacons	Bruce Cassidy	Boston	TD Garden
Boston Red Sox	1901	John Henry	Alex Cora	Boston	Fenway Park
Boston Celtics	1946	Wyc Grousbeck	Brad Stevens	Boston	TD Garden

This is a three (3) part question that parallels our Perl homework, where you created information about your favorite team.

Part I: Using SQL, develop one (1) CREATE TABLE statement that would create a database table within Oracle APEX. Define a primary key, you are welcome to add additional columns as needed to your table. Don't worry about a Foreign key or creating any other tables

Part II: Using SQL, develop a set of five (5) INSERT statements to populate your table with information about each team.

Part III: Create one (1) select statement that selects all columns and rows in your table. Sort it by your team name. Don't use an asterisk (like "SELECT * FROM team"), instead, please specify each column.