Watch 10 SQL Code Challenges for Beginners | T-SQL Practice Statements Video Tutorial

SQL Queries for creating Tables 1. Create table Opposite ( id int, Value int ) Insert into Opposite Values (1,-56),(2,76),(3,-84),(4,96),(5,-47) 2. Create table Divisions ( Division_id int, Year int, Revenue int ) Insert into Divisions Values (1,2018,60),(1,2021,40),(1,2020,70),(2,2021,-10),(3,2018,20),(3,2016,40),(4,2021,50) 3. Create table Century ( id int, Year int ) Insert into Century Values (1,1776),(2,2001),(3,1643),(4,1865),(5,1969) 4. Create Table EvenOdd ( id int, Value int ) Insert into EvenOdd Values (1,4),(2,11),(3,57),(4,24),(5,47) 5. Create Table AgeGroup ( id int, Name char(10), Age int ) Insert into AgeGroup Values (1,'Bob',21),(2,'Sam',19),(3,'Jill',18), (4,'Jim',21),(5,'Sally',19),(6,'Jess',20),(7,'Will',21) 6. Create Table Greeting ( id int, Name char(10) ) Insert into Greeting Values(1,'Bob'),(2,'Sam'),(3,'Jill'),(4,'Jim'),(5,'Sally'),(6,'Jess'),(7,'Will') 7. Create table BestSeller ( id int, Name VARCHAR(10), Amount_Sold int ) Insert into BestSeller Values (1,'Cup',11),(2,'Saucer',22),(3,'Plate',46),(4,'Fork',34),(5,'Spoon',45),(6,'Knife',78), (7,'Mug',23),(8,'Glass',64),(9,'Tumbler',24) 8. Create Table Passport ( id int, Name VARCHAR(20), Country VARCHAR(20) ) Insert into Passport Values (1,'Bob Smith','United States'),(2,'Jim Jones','China'),(3,'Sam White','Japan'), (4,'Jess Black','Canada'),(5,'Will Wilson','Germany'),(6,'Wilson Scott','England'), (7,'Scott Daniels','France'),(8,'Daniel Jackson','Canada'),(9,'Jack Johnson','United States') Blog's URL: https://www.codecademy.com/resources/blog/sql-code-challenges-for-beginners/ If you are ready for Expert Level Challenge, check out my other video: https://youtu.be/3EWHgA-7V9E Please like, comment and subscribe.