sql week number starting monday
BEGIN TRANSACTION;
/* Table Creation And Insertions */
CREATE TABLE week(Number integer PRIMARY KEY, Name text);
INSERT INTO week VALUES(1, 'Monday')
INSERT INTO week VALUES(2, 'Tuesday')
INSERT INTO week VALUES(3, 'Wednesday')
INSERT INTO week VALUES(4, 'Thursday')
INSERT INTO week VALUES(5, 'Friday')
INSERT INTO week VALUES(6, 'Saturday')
INSERT INTO week VALUES(7, 'Sunday')
COMMIT;
/* Queries */
SELECT name AS 'Day'
FROM week
WHERE name = 'Monday';
/* Returns Monday' */