Question

Create a database a class of 10 student with detail or their roll no. Name class mark and apply any 10 sql query on database and show their result..
Ans fast....

Answer 1

Answer:

Database can be created as follows in an attachment which includes Name, Roll No, Class mark, 10 subjects query and results.

1ca892795c6334aeac7dd16a242c2be4.xls

Answer 2

Answer:

CREATE TABLE STUDENTS (  

Roll_no INT                           NOT NULL,  

NAME VARCHAR (20) NOT NULL,  

AGE INT                         NOT NULL,  

City CHAR (25),  

PRIMARY KEY (ID)

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)  

VALUES (1, Abi, 22, Mumbai);  

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)  

VALUES (2, Bala, 20, Chennai);  

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)  

VALUES (3, DISHA, 21, Mumbai);  

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)  

VALUES (4, Ram, 21, Banglore);  

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)  

VALUES (5, Shailaja, 23, Kolatta);  

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)  

VALUES (6, Rohan, 23, Banglore);  

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)  

VALUES (7 , Ramya, 23, Chennai);  

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)  

VALUES (8, Rani, 23, Kerala);  

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)  

VALUES (9, Ragu, 23, Andhra);  

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)  

VALUES (10, Sreya, 23, Kerala);  

Select * from Student;