Select Values Between Two Values Create Table Of Adventurers – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255) ) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (name, age, race) VALUES (‘Fjoak Doom-Wife’, 28, ‘Human’), (‘Alooneric Cortte’, …

Select Highest Value In Each Group Create Table Of Adventurers – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255) ) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (name, age, race) VALUES (‘Fjoak Doom-Wife’, 28, ‘Human’), (‘Alooneric …

Retrieve Subset Of Columns Create Table – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) ) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (name, age, race, weapon) VALUES (‘Fjoak Doom-Wife’, 28, …

Retrieve Rows Based On Multiple Condition Create Table – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (name, age, race, weapon) VALUES (‘Fjoak Doom-Wife’, …

Retrieve Rows Based On Condition Create Table – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) ) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (name, age, race, weapon) VALUES (‘Fjoak Doom-Wife’, …

Retrieve Random Subset Of Rows Note: This code works in PostgreSQL databases, but might not work in other SQL database systems (e.g. MySQL). Create Table – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) ) …

Replace Missing Values Create Table – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) ) Insert Rows With Missing Values – Insert into the table adventurers INSERT INTO adventurers (name, age, race, weapon) VALUES (‘Fjoak …

Rename Columns In Views Create Table – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) ) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (name, age, race, weapon) VALUES (‘Fjoak Doom-Wife’, 28, …

List Tables In Database Create Table – Create table called villains CREATE TABLE villains ( – string variable name varchar(255) ) Create Table – Create table called heroes CREATE TABLE heroes ( – string variable name varchar(255) ) Create Table – Create table called battles CREATE TABLE battles ( – string variable name varchar(255) ) …