Alex A. Reda Axelreed
Axelreed
/ rozenshtein.sql
Last active
April 20, 2021 02:23
— forked from jgn/rozenshtein.sql
Sample schema from Rozenshtein, The Essence of SQL (and see The SQL Cookbook)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| drop table if exists student; | |
| create table student ( | |
| sno integer, | |
| sname varchar(10), | |
| age integer | |
| ); | |
| drop table if exists courses; | |
| create table courses ( | |
| cno varchar(5), |