@Aryan

JOIN

May 04, 2021 · SQL
-- create a table
CREATE TABLE Seller (
S_id INTEGER PRIMARY KEY,
S_name TEXT NOT NULL,
S_city TEXT NOT NULL,
Commission INTEGER
);
CREATE TABLE Orders (
Order_no INTEGER PRIMARY KEY,
Purch_amt Float NOT NULL,
Order_date FORMAT 'dd.mm.yyyy' NOT NULL,

Experiment-4(b)

updated May 01, 2021 · SQL
-- create a table
CREATE TABLE Seller (
S_id INTEGER PRIMARY KEY,
S_name TEXT NOT NULL,
S_city TEXT NOT NULL,
Commission INTEGER
);
CREATE TABLE Orders (
Order_no INTEGER PRIMARY KEY,
Purch_amt Float NOT NULL,
Order_date FORMAT 'dd.mm.yyyy' NOT NULL,