The SQ L syntax for CREATE TABLE is :

CREATE TABLE "table_name"
("column 1" "data_type_for_column_1","column 2" "data_type_for_column_2",... )

Example : 

CREATE TABLE customer
(First_Name char(50),Last_Name char(50),Address char(50),City char(50),Country char(25),
Birth_Date date)


The SQL syntax for SELECT data from Table:


SELECT * FROM Store_Information

Example

Table Store_Information

store_name	Sales	Date
Los Angeles	$1500	Jan-05-1999
San Diego	$250	Jan-07-1999
Los Angeles	$300	Jan-08-1999
Boston	$700	Jan-08-1999