@Suraj123

Join

updated August 15, 2022 · SQL
-- create table
create table Customers(
customer_id integer primary key,
name text NOT null,
city text NOT null,
salary integer NOT null,
role text NOT null,
country text NOT null,
shipper_name text not null
);

Join

updated August 15, 2022 · SQL
-- create table
create table Customers(
customer_id integer primary key,
name text NOT null,
city text NOT null,
salary integer NOT null,
role text NOT null,
country text NOT null
);

-- create second table

Join

August 15, 2022 · SQL
-- create table
create table Customers(
customer_id integer primary key,
name text NOT null,
city text NOT null,
salary integer NOT null,
role text NOT null,
country text NOT null
);

-- create second table

Join

updated August 15, 2022 · SQL
-- create table
create table Customers(
customer_id integer primary key,
name text NOT null,
city text NOT null,
salary integer NOT null,
role text NOT null,
country text NOT null
);

-- create second table

Join

updated August 15, 2022 · SQL
-- create table
create table Customers(
customer_id integer primary key,
name text NOT null,
city text NOT null,
salary integer NOT null,
role text NOT null,
country text NOT null
);

-- create second table

Update

August 06, 2022 · SQL
-- create table
CREATE TABLE Customers(
Customer_id int primary key,
name TEXT NOT NULL ,
city TEXT NOT NULL ,
country TEXT NOT NULL 
);

-- insert data 
INSERT INTO Customers VALUES(1,'Suraj','Dombivli','India');
INSERT INTO Customers VALUES(2,'sachin','Nilje','Brazil');

Update

updated August 06, 2022 · SQL
-- create table
CREATE TABLE Customers(
Customer_id int primary key,
name TEXT NOT NULL ,
city TEXT NOT NULL ,
country TEXT NOT NULL 
);

-- insert data 
INSERT INTO Customers VALUES(1,'Suraj','Dombivli','India');
INSERT INTO Customers VALUES(2,'sachin','Nilje','Brazil');

Update

August 06, 2022 · SQL
-- create table
CREATE Customers(
Customer_id int primary key,
name TEXT NOT NULL ,
city TEXT NOT NULL ,
country TEXT NOT NULL 
);

-- insert data 
INSERT INTO VALUES(1,'Suraj','Dombivli','India');
INSERT INTO VALUES(2,'sachin','Nilje','Brazil');

Update

August 06, 2022 · SQL
-- create table
CREATE Customers(
Customer_id int primary key,
name TEXT NOT NULL ,
city TEXT NOT NULL ,
country TEXT NOT NULL 
);

-- insert data 
INSERT INTO Customers(1,'Suraj','Dombivli','India');
INSERT INTO Customers(2,'sachin','Nilje','Brazil');

Update

August 06, 2022 · SQL
-- create table
CREATE Customers(
Customer_id int primary key,
name TEXT NOT NULL VALUE,
city TEXT NOT NULL VALUE,
country TEXT NOT NULL VALUE
);

-- insert data 
INSERT INTO Customers(1,'Suraj','Dombivli','India');
INSERT INTO Customers(2,'sachin','Nilje','Brazil');

Update

August 06, 2022 · SQL
-- create a table
CREATE TABLE students (
  id INT PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');

UPDATE students

Update

updated August 06, 2022 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');

UPDATE students

Null

August 06, 2022 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  country TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M','Dombivli');
INSERT INTO students VALUES (2, 'Joanna', 'F','Nilje');
-- fetch some values

Null

August 06, 2022 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  country TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M','Dombivli');
INSERT INTO students VALUES (2, 'Joanna', 'F','Nilje');
-- fetch some values

Null

August 06, 2022 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  country TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M','Dombivli');
INSERT INTO students VALUES (2, 'Joanna', 'F','Nilje');
-- fetch some values

Null

August 06, 2022 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  country TEXT is NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
-- fetch some values

Null

August 06, 2022 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  country TEXT is NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M',);
INSERT INTO students VALUES (2, 'Joanna', 'F',);
-- fetch some values

Null

August 06, 2022 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  country TEXT is NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M','');
INSERT INTO students VALUES (2, 'Joanna', 'F','');
-- fetch some values

Null

August 06, 2022 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  country TEXT is NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M','');
INSERT INTO students VALUES (2, 'Joanna', 'F','');
-- fetch some values

Null

August 06, 2022 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  country TEXT NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M','');
INSERT INTO students VALUES (2, 'Joanna', 'F','');
-- fetch some values