project.sqlite

CREATE TABLE REGISTARTION(
FIRST_NAME VARCHAR(50) NOT NULL,
LAST_NAME VARCHAR(50) NOT NULL,
ID_NUMBER NUMBER(10) NOT NULL,
EMAILID VARCHAR(100) NOT NULL PRIMARY KEY,
PASSWORD VARCHAR(20) NOT NULL,
AGE NUMBER(2)
);




CREATE TABLE LOGIN(
EMAILID VARCHAR(100) NOT NULL,
PASSWORD VARCHAR(20) NOT NULL
);



INSERT INTO REGISTARTION VALUES( 'SAMBHAV','THAKUR',180031058,'SAMBHAVKUMAR228@GMAIL.COM','ADMIN',18);
INSERT INTO REGISTARTION VALUES('MANIKANTA','PARNAM',180030365,'MANIKANTA01@GMAIL.COM','ADMIN001',18);
INSERT INTO REGISTARTION VALUES('SIDHHU','GOPARAJU',180030337,'SIDHHU13@GMAIL.COM','SIDHHU',18);
INSERT INTO REGISTARTION VALUES('DHEERAJ','KANCHARLA',180030731,'KANCHARLADHEERAJ@GMAIL.COM','DHEERAJ123',18);
INSERT INTO REGISTARTION VALUES('CHARAN','ATMAKURI',180030036,'CHARAN.SMARTER726@MAIL.COM','CHARANCHANGER',18);



INSERT INTO LOGIN VALUES('SAMBHAVKUMAR228@GMAIL.COM','ADMIN');
INSERT INTO LOGIN VALUES('MANIKANTA01@GMAIL.COM','ADMIN001');
INSERT INTO LOGIN VALUES('SIDHHU13@GMAIL.COM','SIDHHU034');
INSERT INTO LOGIN VALUES('KANCHARLADHEERAJ@GMAIL.COM','DHEERAJ123');
INSERT INTO LOGIN VALUES('CHARAN.SMARTER726@MAIL.COM','CHARANCHANGER');


SELECT COUNT(ID_NUMBER)
FROM REGISTARTION;

SELECT COUNT(AGE)
FROM REGISTARTION
WHERE AGE>=18



 
CREATE TABLE  USER(
 RECEIPTNUMBER NUMBER(10) NOT NULL,
 REQUIREMNTS  VARCHAR(50) NOT NULL,
 ROOMNUMBER  NUMBER(50) NOT NULL
);

INSERT INTO USER(1234,'GROUP',210);
INSERT INTO USER(4567,'LAPTOP',225);
INSERT INTO USER(8901,'LAPTOP',410);
INSERT INTO USER(2468,'PRATICE',409);
INSERT INTO USER(1357,'LAPTOP',307);

 
CREATE TABLE  EVENT(
EVENT_PLACE  VARCHAR(50) NOT NULL,
EVENT_TYPE  VARCHAR(50) NOT NULL,
EVENT_DATE  DATE 
);