SQL Basics 01. SELECT. Database: REXON_METALS. SQLite.

SELECT

Database: REXON_METALS

Table: CUSTOMER

CREATE TABLE CUSTOMER (

CUSTOMER_ID INTEGER PRIMARY KEY AUTOINCREMENT

NOT NULL,

NAME TEXT NOT NULL,

REGION TEXT,

STREET_ADDRESS TEXT,

CITY TEXT,

STATE TEXT,

ZIP INTEGER

);

Query 1

select

*

from customer;

Query 2

select

NAME,

CITY || ',' || STATE as location

from customer;

Database: rexon_metals

Table: PRODUCT

CREATE TABLE PRODUCT (

PRODUCT_ID INTEGER PRIMARY KEY AUTOINCREMENT,

DESCRIPTION TEXT,

PRICE DECIMAL

);

Query 1

select

product_id as id,

price as 'price (USD)',

round(price *1.2) as 'new price(USD)'

from product;