SQL-learning/2trail.sql at main · Nagini-dotcom/SQL-learning · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
CREATE DATABASE collage1;
USE collage1;
CREATE TABLE classroom(
usn INT PRIMARY KEY,
name VARCHAR(50),
marks INT NOT NULL);
INSERT INTO classroom (usn, name, marks)
VALUES
(160, 'NAGINI', 90),
(128, 'Sakshi', 92),
(105, 'Vishnu', 80);
SELECT*FROM classroom;
SELECT*FROM classroom WHERE marks>85;
SELECT*FROM classroom WHERE marks<90;