@Aveena

studentMarks

updated November 29, 2021 · SQL
-- create a table
CREATE TABLE studentMarks (
  id INTEGER PRIMARY KEY,
  f_name TEXT NOT NULL,
  l_name TEXT NOT NULL,
  gender TEXT NOT NULL,
  marks INTEGER NOT NULL
);
-- insert some values
INSERT INTO studentMarks VALUES (1, 'Ryan', 'George', 'M', 90);
INSERT INTO studentMarks VALUES (2, 'Joanna', 'Pattrick', 'F', 85);

SET operators

updated November 27, 2021 · SQL
-- create a table
CREATE TABLE A_customers (
  custID INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  address TEXT NOT NULL
);
CREATE TABLE B_customers (
  custID INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  address TEXT NOT NULL
);

studentFees

November 27, 2021 · SQL
-- create a table
CREATE TABLE studentFees (
  id INTEGER PRIMARY KEY,
  f_name TEXT NOT NULL,
  l_name TEXT NOT NULL,
  fees INTEGER NOT NULL,
  fees_bal INTEGER
);
-- insert some values
INSERT INTO studentFees VALUES (1, 'Ryan', 'George', 20000, 0);
INSERT INTO studentFees VALUES (2, 'Joanna', 'Pattrick', 18000, 1000);

studentDetails

updated November 27, 2021 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  f_name TEXT NOT NULL,
  l_name TEXT NOT NULL,
  gender TEXT NOT NULL,
  age INTEGER,
  dob date
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'George', 'M', 16, "12/01/05");