Question

SQL

Create an access database named student11.

1. Create a table named student12 and insert the following records in it.

ID          StudentName               Grade

1            John                                 90

2            Jim                                    70

3            Larry                               85

4            Sally                                 20

5            Sam                                   60

6            Sandra                            100

7            Runa                                 55

8            Simran                            35

9            Seema                              65

10         Ramu                               75

2. Create a query to find students whose grade are more than or equal to 80.

Answer 1

/*  Create Database */
CREATE DATABASE student11;

/*  Use Database student11  */
Use student11;

/* Create a table called student12 */
CREATE TABLE student12(ID integer PRIMARY KEY, StudentName text, Grade integer);

/* Create few records in this table */
INSERT INTO student12 VALUES(1,'John', 90);
INSERT INTO student12 VALUES(2,'Jim', 70);
INSERT INTO student12 VALUES(3,'Larry', 85);
INSERT INTO student12 VALUES(4,'Sally', 20);
INSERT INTO student12 VALUES(5,'Sandra', 60);
INSERT INTO student12 VALUES(6,'Runa', 100);
INSERT INTO student12 VALUES(7,'Simran', 55);
INSERT INTO student12 VALUES(8,'John', 35);
INSERT INTO student12 VALUES(9,'John', 65);
INSERT INTO student12 VALUES(10,'John', 75);
COMMIT;

/* Display all the records from the table */
SELECT * FROM student12 where Grade >= 80;