forked from shawlu95/Beyond-LeetCode-SQL
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdb.sql
More file actions
46 lines (39 loc) · 968 Bytes
/
Copy pathdb.sql
File metadata and controls
46 lines (39 loc) · 968 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
CREATE SCHEMA IF NOT EXISTS Practice;
USE Practice;
-- ---------------------------------------
--
-- Table structure for table `CourseGrade`
--
DROP TABLE IF EXISTS `CourseGrade`;
CREATE TABLE `CourseGrade` (
`name` varchar(10) NOT NULL,
`course` varchar(10) NOT NULL,
`grade` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `CourseGrade`
--
INSERT INTO `CourseGrade` (`name`, `course`, `grade`) VALUES
('Alice', 'CS106B', 'A'),
('Alice', 'CS229', 'A'),
('Alice', 'CS224N', 'B'),
('Bob', 'CS106B', 'C'),
('Bob', 'CS229', 'F'),
('Bob', 'CS224N', 'F'),
('Charlie', 'CS106B', 'B'),
('Charlie', 'CS229', 'B'),
('Charlie', 'CS224N', 'A'),
('David', 'CS106B', 'C'),
('David', 'CS229', 'C'),
('David', 'CS224N', 'D'),
('Elsa', 'CS106B', 'B'),
('Elsa', 'CS229', 'B'),
('Elsa', 'CS224N', 'A');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `CourseGrade`
--
ALTER TABLE `CourseGrade`
ADD KEY `name` (`name`);