Sql - Challenge
Code Life
By Pierre Marsaa
New season: Step 1
A new season starts and Professor Pi needs three scripts. Each step starts from the original database (trainers and codemon only).
Loading data...
Step 1: the gyms. Create gyms with gym_id (automatic id), name (required and unique), city (text) and type (required text). Insert Tide Gym (Sunset Valley, water), Ember Gym (Azure City, fire) and Boulder Gym (Stone Ridge, rock), then show name, city and type sorted by name.
↗️
Loading editor...
↶
↷
💡 Show Solution
Continue