Question: SQL Create table for favorite teams. Part I: Using SQL, develop one (1) CREATE TABLE statement that would create a database table within Oracle APEX.
SQL
Create table for favorite teams.
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
