Question

Write the SQL query to create the following table:

CUSTOMER
Id
FirstName
LastName
City
Country
Phone

Answer 1

Answer:

create table customer (id number, firstname varchar (n), lastname varchar (n), city varchar (n) , country (n) , phone number (n));

where n is number of digits you want to take.