Chef and Bored Games - CodeChef

 create database ggits;

use ggits;

create table DS_Stud(

ID int not null auto_increment primary key,

Stud_Name varchar(30) not null,

Address varchar(344) not null,

City varchar(50) not null,

Age int not null,

DOB date not null,

Mobile_No varchar (10) not null

);

select * from DS_Stud;

insert into DS_Stud(Stud_Name,Address,Age,DOB,Mobile_No)

values('FOO','HNo-987,Street5',19,'2005-05-03','34545455');

insert into DS_Stud(Stud_Name,Address,Age,DOB,Mobile_No)

values('Bar','something',15,'dateofBirth','21243545');

select Age from DS_Stud;

alter table DS_Stud

add Fee decimal(6,4);

insert into DS_Stud(City)

values('Barcelona');