create database telusko_db;
DROP DATABASE telusko_db;
CREATE SCHEMA telusko_db;
drop schema telusko_db;

create database if not exists telusko_db;

/**
Data Types:
INT - 44,4,78
FLOAT - 4.5,55.2
CHAR => fixed length string, Postal code
VARCHAR => variable length string, FirstName, CIty
DATE => 12/12/2024
TIME => 12:44
DATETIME => 12/12/2024 12:44:44
BOOLEAN => True/False
*/

use telusko_db;

create table personalInfo(
id INT,
name varchar(40),
date_of_birth date,
city varchar(40)
);

create table personalEducation(
id INT,
courses varchar(30),
city_of_education varchar(40)
);

insert into personalInfo(id, name, date_of_birth, city) values (1, 'Akash', '2000-07-22', 'Ganneruvaram');
insert into personalInfo(id, name, date_of_birth, city) values (2, 'Rohit', '2000-07-22', 'Ganneruvaram');
insert into personalInfo(id, name, date_of_birth, city) values (3, 'Ramesh', '2000-10-22', 'Hyderabad');

insert into personalInfo(id, name, date_of_birth, city) values (4, 'Raju', '1999-10-22', 'Banglore'),
(5, 'Kamal', '1998-10-22', 'Pune'),
(6, 'Uday', '1998-07-22', 'Mumbai');