1BEGIN TRANSACTION;
2
3/* Table Creation And Insertions */
4CREATE TABLE week(Number integer PRIMARY KEY, Name text);
5 INSERT INTO week VALUES(1, 'Monday')
6 INSERT INTO week VALUES(2, 'Tuesday')
7 INSERT INTO week VALUES(3, 'Wednesday')
8 INSERT INTO week VALUES(4, 'Thursday')
9 INSERT INTO week VALUES(5, 'Friday')
10 INSERT INTO week VALUES(6, 'Saturday')
11 INSERT INTO week VALUES(7, 'Sunday')
12COMMIT;
13
14/* Queries */
15SELECT name AS 'Day'
16FROM week
17WHERE name = 'Monday';
18
19/* Returns Monday' */